Oracle
1Z0-047 · Question #14
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?
The correct answer is C. SELECT product_id. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASELECT UPPER(product_name)
- BSELECT UPPER(product_name)
- CSELECT product_id
- DSELECT product_jd, UPPER(product_name)
How the community answered
(53 responses)- A8% (4)
- B13% (7)
- C75% (40)
- D4% (2)
Community Discussion
No community discussion yet for this question.