Search Header Logo

SQL_1

Authored by Anjali Luthra

Computers

12th Grade

Used 2+ times

SQL_1
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these is not a DDL Command?

Create

Drop

Update

Truncate

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The UPDATE SQL clause can _____________

update only one row at a time

update more than one row at a time

delete more than one row at a time

delete only one row at a time

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which statement is used to extract data from a database?

Extract

Get

Open

Select

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is a DML command that is used to display record.

DISPLAY

STRUCTURE

WHERE

SELECT

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Write the SQL command to change the datatype of the column SubjectName form char(10) to varchar(50) in table student.

Alter table Student

modify subjectname varchar(50);

Alter table Student

update subjectname varchar(50);

Update Student

modify subjectname char(50);

None

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

_________________ SQL command used to destroy the table named ‘STUDENT ‘ completely from database.

delete Student;

drop table student;

truncate table student;

delete table student;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?