Evaluate the following SQL statement: CREATE INDEX upper_name_idx ON
product_information(UPPER(product_name)); Which query would use the
UPPER_NAME_IDX index?
A.
SELECT UPPER(product_name) FROM product_information;
B.
SELECT product_id FROM product_information WHERE UPPER(product_name) IN
(‘LASERPRO’, ‘Cable);
C.
SELECT UPPER(product_name) FROM product_information WHERE product_id =
2254;
D.
SELECT product_id, UPPER(product_name) FROM product_information WHERE
UPPER(product_name)=’LASERPRO’ OR list_price > 1000;
Explanation: