database:

1.

2.

3.

4.

5.

The special operator used to check whether an attribute value matches a given string pattern is Select one: a. IS NULL O b. BETWEEN O c. LIKE O d. IN All SQL commands must be issued on a single line. Select one: True O False 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? Select one: O a. SELECT ONLY V_CODE FROM PRODUCT; O b. SELECT UNIQUE V_CODE FROM PRODUCT; O c. SELECT DIFFERENT V CODE FROM PRODUCT; O d. SELECT DISTINCT V CODE FROM PRODUCT; A(n) query specifies which data should be retrieved and how it should be filtered aggregated, and displayed. Select one: O a. UPDATE O b. COMMIT O c. SELECT O d. INSERT Which query will output products sorted in ascending order by price? Select one: a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE FROM PRODUCT ORDER BY P_PRICE DESC; b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE FROM PRODUCT ORDER BY 1; C. SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE FROM PRODUCT SORT BY P_PRICE; O d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE FROM PRODUCT ORDER BY P_PRICE ASC