Exam 8: Restricting Rows and Sorting Data

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will return the category and title of all books stored in the BOOKS table presented in order of their category and, for the books in the same category, sort the title of the books in descending order?

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will return all books that cost at least $25.00?

NOT, ALL, and OR are all considered logical operators.

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will display all orders contained in the ORDERS table that have been shipped to the customer?

If a date column is being used for comparison against the search condition, the search condition is enclosed in $\underline { \text { double } }$ quotation marks. _________________________

Which of the following operators can be used to retrieve rows containing NULL values in a specific column?

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will not list the orders that have been shipped to Atlanta or Seattle?

When two conditions are joined by the AND keyword, both conditions must be $\underline { \text { FALSE } }$ for a record to be included in the results. _________________________

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure, which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks.

Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?

A(n) $\underline { \text { percent } }$ sign is used in a search pattern to indicate zero, one, or more characters in a position. _________________________

Contents of BOOKS table -Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display the title and retail price of each book stored in the BOOKS table in order of category and retail price?

A column alias that has been defined in the SELECT clause of a SELECT statement cannot be referenced in an ORDER BY clause.

The ____________________ clause is used to restrict the rows returned by a query.

Logical operators are evaluated in the order of NOT, AND, and OR.

A greater than or equal to comparison is indicated by the symbols $\underline {=> }$ . _________________________

When data is sorted in ascending order, NULL values appear $\underline { \text { first } }$ in the list. _________________________

Which of the following clauses is used to restrict the rows returned by a query?

Which of the following operators can be used to combine search conditions?