Similarly transactional triggers can do dml

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: ot; query types do not allow DML operations and Table of recodes allows DML operations. Similarly Transactional Triggers can do DML operations. QUESTION 34: You are creating a form that will access an Oracle8 database. On which three sources can you base a data block? (Choose three) A. BFILE B. REF column C. Object table - The Power of Knowing 1Z0-132 D. Column object E. INSTEAD-OF trigger Answer: B, C, D Explanation: Data Block can be based on Stored Procedure that returns REF Cursor or Table of Records or it can be based on "FROM" clause query. REF column and Column object and Object table can be selected from the Data Block Wizard. BFILE and INSTEAD-OF Triggers are supported in Oracle Forms but can not be used as sources of Data Block. QUESTION 35: Which three statements describe the functionality of the DO_KEY built-in? (Choose three) A. It accepts both a built-in and a key name as argument. B. If no key trigger is defined, the specified built-in executes. C. Its parameter must be specified in upper case, enclosed in single quotation marks. D. It performs the same task as if you pressed the function key associated with the specified argument. E. It executes the key trigger that corresponds to the built-in specified as its parameter. Answer: B, 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 associated key trigger exists, then the specified built-in subprogram executes. For example, DO_KEY('EXIT_FORM'), when executed, will search for a Key-Exit trigger. If it does not find a Key-Exit trigger, it will execute the EXIT_FORM built-in. DO_KEY accepts built-in names only, not key names: DO_KEY(ENTER_QUERY). To accept a specific key name, use the EXECUTE_TRIGGER QUESTION 36: You are creating a new form for the Order Entry application. You define a record group that will be created when the form is executing this built in: CREATE_GROUP(rg_emplist, global_scope) Which form(s) in the application will have access to this record group? A. All forms in the application. B. Any forms opened by the user who initiated the record group. C. Only the form issuing the CREATE_GROUP built-in. D. Any forms referenced by the form that contains the procedure. Answer: A Explanation: The SCOPE parameter in the CREATE_GROUP built-in Specifies whether the record group can be used only within the current form or within every form in a multi-form application. LOBAL_SCOPE - The Power of Knowing 1Z0-132 Indicates that the record group is global, and that it can be used within all forms in the application. Once created, a global record group persists for the remainder of the runtime session. QUESTION 37: Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically? A. FIND_REPORT_OBJECT B. CANCEL_REPORT_OBJECT C. REPORT_OBJECT_STATUS D. SET_PROPERTY OBJECT_PROPERTY Answer: B Explanation: The CANCEL_REPORT_OBJECT built-in cancels a long-running, asynchronous report. You should verify the report is canceled by checking the status of the report using REPORT_OBJECT_STATUS. The SET_REPORT_OBJECT_PROPERTY built-in is used to change report properties programmatically. The DELETE_TIMER built-in deletes the given timer. QUESTION 38: What does the term application partitioning refer to? A. The feature of a forms application enabling it to run both in client-server mode and on the Web. B. Storing PL/SQL program units between the Oracle server and the application to make optimal use of available resources. C. The nature of a three-tier architecture, where the form module and processing software reside on an application server. D. The feature of a forms application that is able to use Ethernet, twisted pair, and wireless data connections. Answer: B Explanation: PL/SQL program units can be stored in Oracle Server and in the application at the client side. Making such a division will allow optimal use of resources at the server and client because jobs will be divided between the server and client. This applies the term Application Partitioning. QUESTION 39: Which three built-ins can you use to navigate between forms invoked with the OPEN_FORM builtin? (Choose three) A. CLOSE_FORM B. NEXT_FORM C. GO_FORM - The Power of Knowing 1Z0-132 D. PREVIOUS_FORM Answer: B, C, D Explanation: OPEN_FORM opens the form in modeless mode so that users can switch between calling form and called form. To navigate to the form NEXT_FORM, GO_FORM and PREVIOUS_FORM can be used. CLOSE_FORM will close the indicated form. QUESTION 40: Which two triggers are mouse movement triggers? (Choose two) A. When-Mouse-Up B. When-Mouse-Move C. When-Mouse-Down D. When-Mouse-Click E. When-Mouse-Leave Answer: B, E Explanation: Mouse movement triggers are Moving mouse over an item or canvas "WHEN-MOUSEMOVE" or mouse pointer leaves item box or canvas "WHEN-MOUSE-LEAVE". MOUSE-UP, MOUSEDOWN and MOUSE-CLICK are actions of mouse buttons and not considered mouse movement triggers. QUESTION 41: The re...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online