Module 06: Working with Data Blocks and Frames

 Working with Data Blocks and Frames

01. Why would you want to create a control block in a Forms module? 

A. To control all items in other blocks that are not base table items. 

B. To control relationship between a master block and its detail block. 

C. To control the way additional forms are opened and to track the call stack. 

D. To control navigation within the form so that users cannot randomly navigate to any item. 

E. To place various control items (such as buttons) on a single block that is not related to a table in the database.  

Answer: E

02. Order_Id is the primary key for the ORDERS table. A sequence called Orders_Seq has been created for order ID numbers. 

You are designing a form that performs transactions on the ORDERS table. Users will be able to insert, update, delete, and query records using this form. 

Gaps in order ID numbers in the ORDERS table should be kept to a minimum. After the order ID number is assigned to a newly created record, it should be displayed in the fo rm without requerying the data. 

What is the best way to use the Orders_Seq sequence to assign order ID numbers so that these requirements are met? 

A. Set the Initial Value for the Orders.Order_Id item to: SEQUENC E.OR DERS_SEQ.NEXTVAL. 

B. Put the following code into a Pre-Inserted trigger: 

:Orders.Order:Id : = : SEQUENCE.ORDERS_SEQ_NEXTVAL; 

C. Put the following code into a Pre-Inserted trigger: 

SELECT orders_seq.NEXTVAL INTO :Orders.Order_Id 

FROM sys.dual, 

D. Put the following code into a When-Create-Record trigger: 

:Orders.Order:Id : = : SEQUENCE.ORDERS_SEQ_NEXTVAL; 

E. Put the following code into a When-Create-Record trigger: 

SELECT orders_seq.NEXTVAL INTO :Orders.Order_Id 

FROM sys.dual, 

Answer: C

03. You have been asked to correct a problem with a form that was created by another developer. Users complain that they are unable to query on the employee Hire Date, which is a base table item. 

What is a possible cause for this problem? 

A. The Hire Date item is a display item. 

B. The Hire Date item has its Enabled property set to No. 

C. The Hire Date item has its Query Allowed property set to Yes. 

D. The Hire Date item width is not large enough to display the complete date.

Answer: A

04. You create a text item in the Object Navigator. Which property must you change from the default value 50 that the text item will not be part of the SOL statement when a query is issued on the block? 

A. Item Type 

B. Column Name 

C. Conceal Data 

D. Database Item 

Answer: D