What can you do to improve performance without losing

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: s taking longer and harder to retrieve the next set of records. What can you do to improve performance without losing the fast initial response? A. Set Single Record to Yes. B. Set Query All Records to Yes. C. Set Query Array Size to a larger number. D. Set Number of Records Buffered to a larger number. E. Set Number of Records Buffered to a smaller number. F. Set Number of Records Displayed to a smaller number. Answer: D QUESTION 72: In the Products.Fmb module, a trigger currently fires each time you navigate to any item in the Product data block. You want to make a change so that the trigger fires only when you navigate to a specific item. What change should you make to the trigger to correct this behavior? A. Change the Trigger scope from Block to Form. B. Change the Trigger scope from Block to Item. C. Change the Trigger scope from Form to Item. D. Change the Trigger scope from Form to Block. E. Change the Trigger scope from Item to Block. F. Set the Trigger Execution Hierarchy property to After. G. Set the Trigger Execution Hierarchy property to Before. Actualtests.com - The Power of Knowing 1Z0-141 Answer: B QUESTION 73: You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be decided by the user's at run time. How should you define the appropriate data source? A. Define a data block based on Ref Cursor. B. Define a data block based on a Table of Records. C. Define a data block based on a From Clause query. D. Define a data block based on a combination of a Ref Cursor and a Table of Records. E. Define a data block based on a From Clause query and define Transactional triggers for controlling DML statements. Answer: A QUESTION 74: You designed a standard toolbar to accompany a number of forms so the code behind the buttons is written as generically as possible. One of the features of this toolbar is that the buttons are synchronized with the state of the form. To achieve this functionality, you wrote generic procedures that are placed...
View Full Document

Ask a homework question - tutors are online