This preview shows page 1. Sign up to view the full content.
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.
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.
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:
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.
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?
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
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
Actualtests.com - 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
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.
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
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?
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. Actualtests.com - The Power of Knowing 1Z0-132
Which three values are valid parameters for the DO_KEY built-in? (Choose three)
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.
- Fall '09