Module 12: Working with Other Canvas Types

Working with Other Canvas Types

01. 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.  

Answer: B

02. 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

03. Exhibit: 

Examine the PL/SQL block. 

To resolve compiler or run-time errors, what three changes could you make to this code? (Choose three) 

A. Define the BEGIN and END keywords. 

B. Declare PL/SQL variables in anonymous block. 

C. Define an EXCEPTION section to handle exceptions. 

D. Define an EXCEPTION section to declare exceptions. 

E. Define an EXCEPTION section to declare PL/SQL variables. 

F. Define a DECLARE section PL/SQL variables and exceptions. 

Answer: A,C,F