module 7 part #4

Question 1

The SQL data manipulation command HAVING:

a. restricts the selection of rows based on a conditional expression.

b. restricts the selection of grouped rows based on a condition.

c. modifies an attribute’s values in one or more table’s rows.

d. groups the selected rows based on one or more attributes.

Answer 1

b. restricts the selection of grouped rows based on a condition.

Question 2

The _____ command restricts the selection of grouped rows based on a condition.

a. DISPLAY
b. HAVING
c. FROM
d. CONVERT

Answer 2

b. HAVING

Question 3

28. The special operator used to check whether an attribute value is within a range of values is _____.

a. BETWEEN

b. NULL

c. LIKE

d. IN

Answer 3

a. BETWEEN