Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

© examsnet.com

Question : 32

Total: 50

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?

SELECT product_id, UPPER(product_name) FROM product_information WHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;
SELECT UPPER(product_name) FROM product_information;
SELECT UPPER(product_name) FROM product_information WHERE product_id = 2254;
SELECT product_id FROM product_information WHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');

Go to Question:

Prev Question

Next Question