A callform actualtestscom the power of knowing 1z0

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: RY; end if; Answer: C QUESTION 146: Which built-in should be used to invoke one form from another form so that you can navigate between the two? A. CALL_FORM Actualtests.com - The Power of Knowing 1Z0-141 B. OPEN_FORM C. NEW_FORM D. RUN_PRODUCT Answer: B QUESTION 147: Which three statements best describe a Ref Cursor in Forms Builder? (Choose three) A. A stored procedure that uses a Ref Cursor can be used only as a query datasource for a data block. B. A stored procedure that uses a Ref Cursor can be used only as a DML datasource for a data block. C. A stored procedure that uses a Ref Cursor can be used as both a query and a DML datasource for a data block. D. A Ref Cursor is ideal for queries that are dependent only on PL/SQL, and not SQL statements. E. A Ref Cursor enables you to query multiple tables and encapsulate logic in a PL/SQL subprogram. F. A Ref Cursor is used by a stored procedure to return data to a data block. Answer: A,E,F QUESTION 148: You are developing a Human Resourced form for HR clerks to insert, update, and delete records from the EMPLOYEES table. When the user commit records, Forms displays the default informative message "FRM-40400: Transaction complete: <n> records applied and saved". You want to replace that with the message "Records inserted: <n> Records updated: <n> Records deleted: <n>, where <n> represents the number of records inserted, updated, and deleted". Which triggers must you create of modify to accomplish this? A. On-Message only B. Post-Commit and On-Message C. Post-Database-Commit and On-Message D. When-Validate-Record and On-Message E. Post-Insert, Post-Update, Post-Delete, and On-Message Answer: E QUESTION 149: The two-column LOCATION Record Group has 10 rows. At run time, the user wants to mark two or more LOCATION records for use by another Forms Builder object. The rows will be used to construct a WHERE clause for a subsequent data block query. Which built-in enable individual rows to be marked? A. ADD_GROUP_COLUMN B. SET_RECORD_PROPERTY Actualtests.com - The Power of Knowing 1Z0-141 C. GET_GROUP_SELECTION D. S...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online