Evaluate the following SQL statement:CREATE INDEX upper_name_idx -ON product_information(UPPER(product_name));Which quer
Posted: Wed Jun 07, 2023 6:11 am
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;
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;