View the Exhibit and examine the structure of the PORDUCT_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. Option A
B. Option B
C. Option C
D. Option D
the correct answer is D
but why not A