Question: 25. The _____ command restricts the selection of grouped rows based on a condition. a. DISPLAY b. HAVING c. FROM d. CONVERT 26. A(n) _____
25. The _____ command restricts the selection of grouped rows based on a condition.
|
| a. | DISPLAY | b. | HAVING |
|
| c. | FROM | d. | CONVERT |
|
|
|
|
|
|
26. A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.
|
| a. | INSERT | b. | SELECT |
|
| c. | COMMIT | d. | UPDATE |
|
|
|
27. Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
|
| a. | SELECT ONLY V_CODE FROM PRODUCT; | b. | SELECT UNIQUE V_CODE FROM PRODUCT; |
|
| c. | SELECT DIFFERENT V_CODE FROM PRODUCT; | d. | SELECT DISTINCT V_CODE FROM PRODUCT; |
|
|
|
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 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
