Module 14: Producing Triggers

Producing Triggers

01. Examine the PL/SQL code. The code uses the valmess package. To resolve compiler or run-time errors, what changes should you make to the trigger code? 

 A. No changes are required. 

B. Delete the BEGIN and END keywords.

C. Define an EXCEPTION section to handle exceptions.

D. Define all Forms Builder variables with the format: block_name.item_name.  

E. Define a DECLARE section to declare PL/SQL variables.    

Answer: D

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

03. In the Customer application, you want to display the salesperson’s name for each customer. In the CUST block, you create a display item, salesperson. The display item will be populates using a WHEN-VALIDATE-ITEM trigger on the Cust_id text item.

This is the trigger code:

SELECT name

INTO ________

FROM employee

WHERE id = :cust.cust_id;

Choose the option that best completes the INTO clause.

A. sales_person

B. :sales_person

C. cust.sales_person

D. :cust.sales_person

Answer: D

04. You are creating a general ledger application and want the detain for posted general applications to be stored in a temporary table before they are committed to the general_entry table.

Which built-in can you use in a pre-commit trigger to create this temporary table?

A. FORMS_OLE

B. FORMS_DDL

C. USER:EXIT

D. HOST

Answer: B

05.Which statement is true about using built-is in Forms applications?

A. Unrestricted built-ins do not affect logical or physical navigation, and can be called from any form trigger or from any database trigger.

B. Restricted built-ins affect navigation in your form, and can be called only from database triggers and stored procedures.

C. Unrestricted built-ins do not affect logical or physical navigation, and can be called from any form trigger or from any subprogram.

D. Restricted built-ins affect navigation in your form, and can be called only from form triggers while navigation is occurring.

Answer: C

06. You want to create a temporary table while executing a procedure in a form. 

Which statement is true? 

A. You cannot create a table form within Forms. 

B. You must use the FORMS_DDL built-in to create the table. 

C. You must use the DBMS_DYNAMIC_DDL package to create the table. 

D. You can write the CREATE TABLE statement directly into the trigger. 

Answer: B

07. What built-in allows you to manipulate table structures at runtime?

A. RUNTIME_DDL

B. FORMS_RUNTIME

C. FORMS_DDL

D. DDL_FORMS

E. DDL_RUNTIME

Answer: C