Oracle
1Z0-071 · Question #158
1Z0-071 Question #158: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #158. The question stem and answer options stay visible for context.
Question
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?
Exhibit
Options
- ASELECT product_id, UPPER(product_name)
- BSELECT UPPER(product_name)
- CSELECT UPPER(product_name)
- DSELECT product_id
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.