When setting optimizer hints,____ forces the optimizer to use the P_QOH_NDX index to process this query.
A) ALL_ROWS
B) FIRST_ROWS
C) INDEX(P_QOH_NDX)
D) OPTIMIZATION_ROWS

Question

Quizplus · Accepted Answer

The correct syntax for setting an optimizer hint to use a specific index in Oracle is INDEX(index_name). Therefore, the correct choice is C, which specifies to use the P_QOH_NDX index. The other options (A, B, and D) are not relevant to index hints.

When Setting Optimizer Hints,____ Forces the Optimizer to Use the P_QOH_NDX