CSIT156

both b and c Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders shipped between April 4, 2003 and April 5, 2003? %H% Which of the following search patterns could be used to find the word HELLO in Oracle11g? DESC To instruct Oracle11g to sort data in descending order, enter ____ after the column name in the ORDER BY clause. comparison operator A(n) ____ is used to indicate how data should relate to a given search condition. none of the above Which of the following operators can be used to retrieve rows containing NULL values in a specific column? percent sign (%) Which of the following symbols is a wildcard character that can represent any number of characters in a WHERE clause? numeric When sorting the results in descending order, which of the following values will be presented last in the output? NOT Which of the following is NOT a comparison operator? SELECT * FROM orders WHERE shipdate IS NOT NULL ORDER BY customer#, order#; Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#? all of the above Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all books published in 2001? logical operators When the WHERE clause contains multiple types of operators, which of the following is resolved last? both a and b The order in which NULL values appear in the results can be overridden by which of the following keywords? arithmetic operations When the WHERE clause contains multiple types of operators, which of the following is resolved first? SELECT * FROM books WHERE cost = 25.00; 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? numeric When sorting the results in ascending