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

Verified
Correct Answer:
Verified
Q1: To work with data, the DBMS must
Q11: _ are ordered sets of values that
Q19: The _ table space is used to
Q26: End users and the DBMS interact through
Q34: Most current-generation relational DBMSs perform automatic query
Q46: All transaction management commands are processed during
Q48: The DBMS the data and sends the
Q61: List and describe some typical DBMS processes.
Q63: The _ must be set large enough
Q72: DBMS query processing has _ phases.