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
WHERE product_jd = 2254;
B.
SELECT UPPER(product_name)
FROM product_jnformation;
C.
SELECT product_id
FROM product_jnformation
WHERE UPPER(product_name) IN (‘LASERPRO’, ‘Cable);
D.
SELECT product_jd, UPPER(product_name)
FROM product_information
WHERE UPPER(product_name)=’LASERPRO’ OR list_price > 1000;