When Setting Optimizer Hints, _____ Instructs the Optimizer to Minimize

question 74

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

---

Definitions:

Negotiable Instruments

Negotiable Instruments are written documents guaranteeing the payment of a specific amount of money to the bearer or named party, such as checks, promissory notes, and drafts.

Unconditional Promise

A pledge or assurance given without any prerequisites or contingencies.

Specific Sum

A fixed amount of money that is defined and stipulated within a contract or legal document.

Unenforceable

A term describing a contract or clause that cannot be legally enforced or compelled by court.