Oracle Fusion Middleware 11g: Build Applications with Oracle Forms - 1z0-151 FREE EXAM DUMPS QUESTIONS & ANSWERS

View the Exhibit.

You have integrated the WebUtil utility into the Orders form. You code a When-Button- Pressed trigger to call some WebUtil functionality, and then run the form to test it.
Everything works as it should.
You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.
What is a probable cause of this error?

You have a form with a single multi-record block. During a session, a user performs an insert and clicks Save What is the behavior of the record being inserted violates a database constraint?

You want to use WebUtil functionality in the Orders form. What three things must you do to integrate WebUtil into the Orders Form?

The Orders form, whose properties have not been changed from the default, has two non- base table text items to display the sales representative's first and last names.
You want to ensure that entries made in these Items correspond to an existing employee, so you write a When-Validate-Item trigger for the Sales_Rep_First_Name text item:
SELECT LAST_NAME Into :last_name FROM employees
WHERE first_name = :first_name;
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE ('There is no sales rep by this name');
When you test the form and enter a first name that does not exist in the database, the message that you specified appears, but the cursor goes to the Sales_Rep_Last_Name item. You want the cursor to remain in the Sales_Rep__First Name item until a correct first name is entered.
Also, as you continue to test the form, at times, the cursor does not leave the Sales_Rep_First_Name item after you enter a name, but no error message appears.
Which two things can you do to correct these problems?

You are planning the alerts that are needed for your Human Resources application. You wish to display the following in alerts:
* A message to inform the user about being at the just record
* A warning about a potential conflict with the data just entered
* A message to display a validation error to the user
* A warning that the salary is out of range and that asks whether the user wants to correct it You want the note symbol (

) to appear on alerts that display only informative messages, the warning symbol to appear on messages where you will allow the user to continue despite some data problem, and the alarm boll symbol to appear where the user will not be allowed to continue without correcting the situation that caused the alert to be displayed.
You want to define the minimum number of alerts possible and customize them at run time.
Which alerts should you define?

The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FROM SYS.dual;
Which statement is true about this code?

A user at a remote location reports a problem that occurs when the Orders; form runs and the user clicks the invoice button. You are not able to reproduce the problem, so you decide to use remote debugging.
The steps involved in diagnosing the problem are listed below, but they are ordered incorrectly. What is the correct sequence of Steps?
1. You set a breakpoint in the When Button-Pressed trigger for the invoice button.
2. The user's screen goes blank.
3. The user reports the host and port to you.
4. You uses the debugger to step through the code.
5. The user clicks a button that calls DEBUG.ATTACH.
6. You attach to the user's process.
7. You open the Orders.fmb file from which the running .fmx was generated.
8. The user clicks the invoice button.

Immediately after creating a button in the Layout Editor, what is true about the button?

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?