SQL Quiz 3

Which SQL keyword is used to sort the result set?

• ORDER BY

• SORT

• SORT BY

• FILTER

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

• SELECT * FROM Persons ORDER BY FirstName DESC;

• SELECT * FROM Persons ORDER ON customer_name;

• SELECT * FROM Persons ORDER customer_name;

• SELECT * FROM Persons SORT BY 'FirstName' DESC;

With SQL, how can you return the number of records in the "Persons" table?

• SELECT COUNT(*) FROM Persons;

• SELECT COLUMNS() FROM Persons;

• SELECT COUNT() FROM Persons;

• SELECT COLUMNS(*) FROM Persons;

Which SQL statement will select all rows from a table called "Customers" and orders the result by "customer name"?

• SELECT * FROM Customers ORDER BY customer_name;

• SELECT * FROM Customers ORDER ON customer_name;

• SELECT * FROM Customers ORDER customer_name;

• SELECT * FROM Customers ORDERED customer_name;

Which of the following are the five built-in aggregate functions provided by SQL?

• COUNT, SUM, AVG, MAX, MIN

• SUM, AVG, MIN, MAX, MULT

• SUM, AVG, MULT, DIV, MIN

• SUM, AVG, MIN, MAX, NAME

Choose the correct order of keywords in a SELECT statement

• HAVING, GROUP BY, ORDER BY

• HAVING, ORDER BY, GROUP BY

• GROUP BY, HAVING, ORDER BY

• GROUP BY, ORDER BY, HAVING

The ... operator compares the value of the attribute to each value returned by the subquery. This keyword (which must follow a comparison operator) returns TRUE if the comparison is TRUE for any of the values in the column that the subquery returns.

• ANY

• ALL

• EXISTS

• AT LEAST

The ... operator (which must follow a comparison operator) compares the value of the attribute to every value returned by the subquery. The result is true if all rows yield true. The result is false if any false result is found.

• ALL

• ANY

• EXISTS

• EVERY

Write the possible operator when the result of a subquery is multiple values (multiple fields).

• IN

• «=»

• «< >»

• none of the given

SQL allows testing the emptiness of a subquery's result using the ... keyword.

• EXISTS

• ANY

• ALL

• IS NULL