Free Oracle 1z1-151 Exam Dumps Questions & Answers

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.  No. It is too late to perform a rollback at this stage because the update has already been applied.
• C.  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.

Your company applies three different interest rates for customers based on their credit rating, which is classified as being Excellent, Fair, Poor or Unknown.
In the years past, clerks entered credit ratings manually, which resulted in some of them being mistyped. To improve data entry accuracy you modify the Customers form so that the Credit_Rating item is a static list item that allows only those four values.
Users report to you that some of the customer records can no longer be accessed when they use the modified Customers form. How can you fix this problem?

• A.  Set the Query Allowed Property for the list Item.
• B.  Set the Mapping of Other Values property for the list item.
• C.  Users must re-enter the records for those customers that cannot be accessed.
• D.  Ensure that required is set to No for the list item so that a blank line appears in the list.
• E.  Set the Default Value property for the list item.

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

What happens when you click Run Form Debug in Forms Builder?

• A.  The form runs on your local machine by using a debug executable client.
• B.  The form runs in a simulated three-tier environment by using an applet viewer that is included with the product to enable debugging.
• C.  The form runs in a three tier environment by using the [debug] configuration in the FORMSWEB.CFG file.
• D.  The form runs in a three-tier environment by using the application server URL that you specify in runtime preferences.

To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.
You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?

• A.  The MESSAGE () built-in is not allowed in validation triggers.
• B.  Validation for the Customer_Id item failed.
• C.  The validation unit of the form needs to be changed.
• D.  The item is using an LOV for validation.
• E.  The form is in Enter-Query mode.
• F.  There is a syntax error in the call to the MESSAGE() built-in.