Week #9 Quiz - CIST1220-Structured Query Language-SQL

An ORDER BY clause can reference a column to be used for sorting based upon its position in the database table. A) True B) False

B) False

Search conditions for data contained in non-numeric columns must be enclosed in double quotation marks. A) True B) False

B) False

Which of the following operators can be used to combine search conditions? A) AND B) = C) IS NOT NULL D) none of the above

A) AND

Retrieving only specific rows from a table is a process known as selection. A) True B) False

A) True

A(n) ____ is used to indicate how data should relate to a given search condition. A) comparison operator B) logical operator C) search pattern D) criteria

A) comparison operator

Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit? A) SELECT * FROM books WHERE profit > .6; B) SELECT * FROM books WHERE (retail-cost)/cost > .60; C) SELECT * FROM books WHERE (retail-cost)/cost > 60%; D) SELECT * FROM books WHERE (retail-cost)/cost > '60';

B) SELECT * FROM books WHERE (retail-cost)/cost > .60;

Which of the following is true? A) Character values are not case-sensitive B) Character strings must be enclosed in double quotation marks C) Date values are enclosed in single quotation marks D) Date values are not format-sensitive

C) Date values are enclosed in single quotation marks

Which of the following is a valid comparison operator? A) != B) IN C) ^= D) all of the above

D) all of the above

The order in which NULL values appear in the results can be overridden by which of the following keywords? A) NULLS FIRST B) NULLS LAST C) NSEQ D) both a and b

D) both a and b

Which of the following are examples of comparison operators used in the WHERE clause? A) =, >, <, <=, >=, <> B) between ___ and ___ C) in (..,..,.. ) D) like E) is null F) All of the above

F) All of the above