SQL Quiz

What is a ‘tuple’?

• A row or record in a database table

• Another name for the key linking different tables in a database.

• An attribute attached to a record.

• Another name for a table in an RDBMS.

The command to remove rows from a table ‘CUSTOMER’ is:

• REMOVE FROM CUSTOMER …

• DROP FROM CUSTOMER …

• DELETE FROM CUSTOMER WHERE …

• UPDATE FROM CUSTOMER …

The command to eliminate a table from a database is:

• REMOVE TABLE CUSTOMER;

• DROP TABLE CUSTOMER;

• DELETE TABLE CUSTOMER;

• UPDATE TABLE CUSTOMER;

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included

• ONLY

• UNIQUE

• DISTINCT

• SINGLE

With SQL, how do you select all the columns from a table named "Persons"?

• SELECT [all] FROM Persons

• SELECT Persons

• SELECT * FROM Persons

• SELECT *.Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

• SELECT [all] FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName<>'Peter'

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

• SELECT * FROM Persons WHERE FirstName='a'

• SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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

• SELECT * FROM Persons WHERE FirstName LIKE '%a'

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

• SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

• SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

• SELECT FirstName='Peter', LastName='Jackson' FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

• SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

• SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

• SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

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

• SELECT * FROM Persons SORT 'FirstName' DESC

• SELECT * FROM Persons ORDER BY FirstName DESC

• SELECT * FROM Persons SORT BY 'FirstName' DESC

• SELECT * FROM Persons ORDER FirstName DESC