database:

1.

2.

3.

4.

5.

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is Select one: O a. LIKE O b. IN O c. BETWEEN O d. IS NULL The special operator used to check whether an attribute value is within a range of values is Select one: a. NULL O b. LIKE O c. BETWEEN O d. IN Which SQL statement will list the names and phone numbers of vendors who supply any product with price above $100? Select one: O a. SELECT V NAME, V PHONE FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE WHERE P.P PRICE > 100; O b. SELECT V_NAME, V_PHONE FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE OR P.P PRICE > 100; O c. SELECT V_NAME, V_PHONE FROM PRODUCT P JOIN VENDOR V ON P.V_CODE = V.V_CODE WHERE P.P PRICE 100); Which query will output the rows where the value of P_PRICE is between 50 and 100 (inclusive)? Select one: a. SELECT * FROM PRODUCT WHERE P_PRICE >= 50 AND P_PRICE =100; d. SELECT * FROM PRODUCT WHERE P_PRICE >= 50 OR P_PRICE