nerdexam
Oracle

1Z0-141 · Question #132

View the Exhibit. You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table…

The correct answer is D. Set Number of Records Buffered to a larger number. See the full explanation below for the reasoning.

Question

View the Exhibit. You are developing and testing a Forms application on a machine that has plenty of memory. The Customers block, whose Property Palette is shown in the exhibit, is based on a table that contains a large number of records. The initial query on the block appears quickly. However, after scrolling through hundreds of records in the block, you notice that it is taking longer and longer to retrieve the next set of records. What can you do to improve performance without losing the fast initial response?

Exhibit

1Z0-141 question #132 exhibit

Options

  • ASet Single Record to Yes.
  • BSet Query All Records to Yes.
  • CSet Query Array Size to a larger number.
  • DSet Number of Records Buffered to a larger number.
  • ESet Number of Records Buffered to a smaller number.
  • FSet Number of Records Displayed to a smaller number.

How the community answered

(26 responses)
  • A
    12% (3)
  • B
    4% (1)
  • D
    81% (21)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-141 Practice