IS 1401-Quiz 2

Which of the following SQL clauses is used to DELETE tuples from a database table?

• DELETE

• REMOVE

• DROP

• CLEAR

Which of the following is NOT a DDL command?

• UPDATE

• TRUNCATE

• ALTER

• None of the mentioned

What does DML stand for?

• Different Mode Level

• Data Model Language

• Data Mode Lane

• Data Manipulation language

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

• SELECT * FROM Persons WHERE FirstName=’a

• SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

• SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

• SELECT * FROM Persons WHERE FirstName=’%a%’

With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

• SELECT * FROM Persons SORT BY ‘FirstName’ DESC

• SELECT * FROM Persons ORDER FirstName DESC

• SELECT * FROM Persons SORT ‘FirstName’ DESC

• SELECT * FROM Persons ORDER BY FirstName DESC

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

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

• UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

• MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

• MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

• UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

Which of the following is NOT true about SQL statements?

• SQL statements are not case sensitive.

• SQL statements can be written on one or more lines.

• Keywords cannot be split across lines.

• Clauses must be written on separate lines.

Which of the following code will successfully delete the table LOCATIONS from the database?

• DROP TABLE locations;

• DELETE TABLE locations;

• TRUNCATE TABLE locations;

• None of the above

You can add a row using SQL in a database with which of the following?

• ADD

• CREATE

• INSERT

• MAKE