Multiple Choice
When setting optimizer hints,____ instructs the optimizer to minimize the overall execution time,that is,to minimize the time it takes to return all rows in the query result set.This hint is generally used for batch mode processes.
A) ALL_ROWS
B) FIRST_ROWS
C) INDEX(P_QOH_NDX)
D) OPTIMIZATION_ROWS
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q5: The table space is used to store
Q11: _ are ordered sets of values that
Q25: All factors must be checked to ensure
Q35: _ refers to the number of different
Q37: All data in a database are stored
Q38: Indexes do not facilitate join operations.
Q44: Database _ activities can be divided into
Q45: Working with data in the data cache
Q52: Once an SQL statement is transformed, the
Q67: A cost-based optimizer uses a set of