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:

Creditor

An individual or institution to whom money is owed.

Technical Default

A failure to meet some specific terms of a loan agreement, lease, or another contract, other than the failure to make payments as and when they fall due.

Interest Payments

Payments made by a borrower to a lender, consisting of the cost of borrowing money over a period of time.

Principal Payments

Payments made towards the original amount borrowed in a loan, excluding interest payments, thereby reducing the outstanding principal balance.