SQL_1

Which of these is not a DDL Command?

• Create

• Drop

• Update

• Truncate

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'

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

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

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

• DISPLAY

• STRUCTURE

• WHERE

• SELECT

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

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

• delete Student;

• drop table student;

• truncate table student;

• delete table student;

SQL query to find all the cities whose humidity is 95.

• SELECT city WHERE humidity = 95

• SELECT city FROM weather WHERE humidity = 95

• SELECT humidity = 89 FROM weather

• SELECT city FROM weather

Less than or equal to?

• >=

• =>

• =<

• <=

How would we script a SQL query to select "Description" from the Item table?

• SELECT Item.Description

• EXTRACT Description FROM Item

• SELECT Item FROM Description

• SELECT Description FROM Item