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 the total number of 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
Q65: Good database performance is easy to evaluate.
Q66: During the _ phase, the DBMS retrieves
Q67: The _ cache is used as a
Q68: The _ table space is the most
Q69: Why do we need to optimize a
Q70: Maximizing disk contention is one of the
Q71: Automatic query optimization means that the:<br>A) optimization
Q72: DBMS query processing has _ phases.
Q73: A(n) _ request is a low-level read
Q75: Knowing the sparsity of a column helps