Which symbol when used in an object's Property Palette, indicates an inherited property that has been changed?

• A. Option D
• B. Option A
• C. Option B
• D. Option C

On the Employees form, you do not want the cursor to enter the Employee_Id text item, which is the first item in the first block on the form. You code a Pre-Text-item trigger for that item that uses the GO_ITEM built-in to navigate to the next item.
What happens when you run the form from Forms Builder?

• A. The form runs, but as soon as you perform any navigation, a runtime error occurs.
• B. You receive a compilation error.
• C. The form starts to run, but immediately closes. So If an error message Is displayed, you are unable to see it.
• D. The form runs, but as soon as it appears, you receive a runtime error.
• E. The form runs with no problem.

View the Exhibit.

You have placed the following code in a Post insert trigger on the Orders block:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FORM SYS.dual;
You have also set Item properties for the Order_Id Item in the form so that users cannot directly enter an Order ID.
As the SUMMIT user, you run the form to test it. Yon are able to insert a record in the block, but when you click Save, you have a database error as shown in the Exhibit.
What is the probable cause of this error?

• A. You should assign a temporary value to the Order_Id item before saving the form.
• B. The code should be in a database trigger instead
• C. The code should be in Pre_insert trigger instead
• D. You should create the sequence in the database, because the runtime error is an indication that is does not exist.
• E. You should change the code to select the sequence number from SUMMIT.dual instead.

View the Exhibit.

You are creating a menu for use with several forms. You create the structure of the menu in the Menu Editor.
As shown in the Object Navigator in the Exhibit, which objects are menu items?

• A. MENU3 and ITEM5_MENU only
• B. ITEM4, ITEM5, and ITEM6 only
• C. MENU3, ITEM4, ITEM5, ITEM5_MENU, and ITEMG
• D. MENU3 only
• E. ITEM5 and ITEM only
• F. ITEM6 only
• G. ITEM4 and ITEM5 only
• H. ITEM 4 and ITEM6 only

You put some code in a Post_Update trigger and raise the FORM_TRIGGER_FAILURE under certain conditions. Does a rollback take place if the trigger falls?

• A. Yes. Although the update has been applied to the database, the old column values are retained as rollback data; so a failure of this trigger automatically reinstates the original values.
• B. The value have already been applied, so you must programmatically save the old values in the global variables or PL/SQL variables if you want to reinstall the original values.
• C. No. It is too late to perform a rollback at this stage because the update has already been applied.