Oracle
1Z0-141 · Question #89
The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the…
The correct answer is D. Query Array Size: 0. See the full explanation below for the reasoning.
Question
The Orders table in the database contains several thousand records. There is a block in the Orders form that is based on the ORDERS table and displays one record. The block is ordered by the Order_Date in descending order, because order entry clerks usually must access only the most recent orders. Which one of the following combinations of property settings for the Orders block will provide the fastest response time before a record appears in the block upon executing a query?
Options
- AQuery Array Size: 0
- BQuery Array Size: 1000
- CQuery Array Size: 1000
- DQuery Array Size: 0
- EQuery Array Size: 0
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- D75% (18)
- E17% (4)
Community Discussion
No community discussion yet for this question.