Record groups cannot be used as a source for a data

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: me and used for a programmatically created record group or design time record group. Record groups can be populated using the POPULATE_GROUP_WITH_QUERY built-in. Record groups cannot be used as a source for a data block, menu item, or FROM clause query. QUESTION 85: Which scenario describes an appropriate use for opening a form in a new session? A. The data entered into the called form is logically independent of the data entered in the calling form. B. The called form requires different privileges than the calling form. C. The called form must execute as a different user than the calling form. D. The calling form must be able to query data in the called form before it is saved. Answer: A Explanation: OPEN_FORM and CALL_FORM are built-ins that can invoke a form. Only the OPEN_FORM built-in can invoke a form using a new database session by using the SESSION_MODE parameter. For example: OPEN_FORM ('customer',ACTIVATE,SESSION); The SESSION keyword instructs Forms to open the CUSTOMER form with a new session. Therefore, DML operations performed in the CUSTOMER form will be part of a separate transaction. Committing in the CUSTOMER form will not affect the transaction in the ORDER form. QUESTION 86: You create a multiple form application- Which built-in must you use to invoke the form modules to enable you to programmatically control navigation between the multiple forms in your application? A. NEW_FORM B. OPEN_FORM C. CALL_FORM D. CLOSE_FORM Answer: B Explanation: Because OPEN_FORM opens forms as modeless windows, users can switch freely to different open forms. Therefore, it is most appropriate for invoking forms from the application-system menu. However, a disadvantage of using OPEN_FORM is that it is hard to keep multiple open forms synchronized. QUESTION 87: You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large - The Power of Knowing 1Z0-132 amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block? A. Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. B. Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. C. Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. D. Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. E. Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure. Answer: E Explanation: Data block can be based on stored procedure that uses REF cursors. Basing data blocks on such procedures can be done using the Data Block Wizard. Select Stored Procedures as the data type of the data block. QUESTION 88: You want the user to toggle between two states of a check box in the SALES data block. When the box is checked the value is 'True' and if it is unchecked the value is 'False'. Which built-in could you use in a When-Checkbox-Changed trigger to obtain the current master/detail query behavior? A. GET_BLOCK_PROPERTY B. GET_RELATION_PROPERTY C. SET_RELATION_PROPERTY D. WHEN_MOUSE_CLICK E. LIST_VALUES Answer: A Explanation: GET_BLOCK_PROPERTY Returns information about a specified block. COORDINATION_STATUS parameter For a block that is a detail block in a master-detail block relation, this property specifies the coordination status of the block with respect to its master block(s). Returns the VARCHAR2 value COORDINATED if the block is coordinated with all of its master blocks. If it is not coordinated with all of its master blocks, the built-in returns the VARCHAR2 value ON_COORDINATED. Immediately after records are fetched to the detail block, the status of the detail block is COORDINATED. - The Power of Knowing 1Z0-132 QUESTION 89: Which three values are valid parameters for the DO_KEY built-in? (Choose three) A. ENTER B. GO_ITEM C. VALIDATE D. EXIT_FORM E. EXECUTE_QUERY Answer: A, D, E Explanation: The DO_KEY built-in function executes the key trigger associated with the built-in that is specified as its parameter. If no such key trigger exists, then the specified subprogram executes. The parameter must be a built-in that is associated with a key trigger. VALIDATE GO_ITEM are not a built-in that can be executed by the defa...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online