Chapter 3

Question 1

Which clause allows you to sort column data in ascending or descending order?

a. ORDER BY
b. FROM
c. WHERE
d. BETWEEN

Answer 1

a. ORDER BY

The ORDER BY clause retrieves the name of one or more columns from the SELECT statement and then sorts (ascending or descending) the output.

Question 2

Which operator, when used with the WHERE clause, lets you match any condition opposite of the one defined?

a. BETWEEN
b. IN
c. NOT
d. AND

Answer 2

c. NOT

NOT is a logical operator used to match any condition opposite of the one defined.

Question 3

What operator is used to perform wildcard-character filtering?

a. AND
b. SELECT
c. IS NULL
d. LIKE

Answer 3

d. LIKE

Like is used to filter data that fits a pattern

Question 4

Why wont the following SQL statement work?

SELECT*
FROM CHECKS
ORDER BY Desc;

a. The order by clause doesn’t specify any column names.
b. The query is missing a WHERE clause.
c. There are no column names specified after SELECT
keyword.
d. The desc keyword should be capitalized.

Answer 4

a. The ORDER BY clause doesn’t specify any column names.

The ORDER BY clause must be used with at least one column name.

Question 5

Which of the following is (are) used to specify a set of characters?

a. Semicolon
b. Select
c. Brackets
d. Colon

Answer 5

c. Brackets

Specified characters are placed within brackets.