View the Exhibit and examine the structure of the PRODUCT_INFORMATION table. (Choose the best answer.)
PRODUCT_ID column is the primary key. You create an index using this command:
SQL > CREATE INDEX upper_name_idx ON product_information(UPPER(product_name));
No other indexes exist on the PRODUCT_INFORMATION table.
Which query would use the UPPER_NAME_IDX index?
A. SELECT product_id, UPPER(product_name)
FROM product_information
WHERE UPPER(product_name) = ‘LASERPRO’ OR list_price > 1000;
B. SELECT UPPER(product_name)FROM product_information;
C. SELECT UPPER(product_name)FROM product_information
WHERE product_id = 2254;
D. SELECT product_id
FROM product_information
WHERE UPPER(product_name) IN (‘LASERPRO’, ‘CABLE’);
|
Download Printable PDF. VALID exam to help you PASS. |
 |