If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in _____________.
a. double quotation marks (" ") c. parentheses ( )
b. single quotation marks (' ') d. none of the above
____ 2. Which of the following operators would be most appropriate to determine whether or not the retail price of a book is at least $24.00?
a. LIKE c. >
b. BETWEEN d. >=
____ 3. Which of the following is not a valid comparison operator?
a. => c. ^=
b. <> d. none of the above
____ 4. Which of the following symbols is a wildcard character that can represent any number of characters?
a. asterisk (*) c. question mark (?)
b. underscore (_) d. percent sign (%)
____ 5. Which of the following operators can be used to combine search conditions?
a. AND c. IS NOT NULL
b. = d. none of the above
____ 6. Which of the following clauses is used to indicate a particular sort sequence for presenting query results?
a. SELECT c. WHERE
b. SORT BY d. ORDER BY
____ 7. When sorting the results in ascending order, which of the following values will be presented last in the output?
a. character c. NULL
b. numeric d. date
____ 8. When sorting the results in ascending order, which of the following values will be presented first in the output?
a. numeric c. NULL
b. character d. date
____ 9. To instruct Oracle9i to sort data in descending order, enter _______ after the column name in the WHERE clause.
a. d c. desc
b. des d. none of the above
____ 10. The order that NULL values appear in the results can be overridden by which of the following keywords?
a. NULLS FIRST c. NSEQ
b. NULLS LAST d. both a and b
Contents of BOOK table
____ 11. Which of the following queries will return all books that cost at least $25.00?
a. SELECT * FROM books
WHERE cost > $25.00;
b. SELECT * FROM books
WHERE cost >= 25.00;
c. SELECT * FROM books
WHERE cost >= $25.00;
d. none of the above
____ 12. Which of the following queries will list the title and retail price of each book stored in the BOOKS table, sorted in order of the book titles?
a. SELECT title, retail FROM books
ORDERED BY title;
b. SELECT title, retail FROM books
SORTED BY title;
c. SELECT title, retail FROM books
ORDER BY title;
d. SELECT title, retail FROM books
SORT BY title;
Contents of the ORDERS table
____ 13. Which of the following SQL statements will display how long it took to ship order# 1007 (based upon when the order was originally placed)?
a. SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1007;
b. SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE 1_7%;
c. SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1_7%;
d. SELECT order#, shipdate-orderdate FROM orders WHERE order# LIKE '1_7%';
____ 14. Which of the following SQL statements will list all orders placed by customer# 1020 that have not yet been shipped?
a. SELECT * FROM orders WHERE customer# = 1020 OR shipdate = NULL;
b. SELECT * FROM orders WHERE customer# = 1020 AND shipdate IS NULL;
c. SELECT * FROM orders WHERE customer# = 1020 OR shipdate IS NULL;
d. SELECT * FROM orders WHERE customer# = 1020 AND shipdate = NULL;
