Free Oracle 1z1-151 Exam Dumps Questions & Answers

Which three are valid ways to populate a display item?

• A.Executing a query
• B.Calculation
• C.When-Button-Pressed trigger
• D.initial Value property
• E.User input

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.

• A.3, 6, 5, 7, 8, 1, 2, 4
• B.8, 3, 6, 5, 4, 7, 1, 2
• C.7, 1, 3, 6, 5, 1, 8, 4
• D.5, 3, 6, 7, 1, 8, 2, 4

You are coding a When-Checkbox-Changed trigger.
Which statements are available for use in your code?

• A.unrestricted built-ins only
• B.PL/SQL statement-, and any built-ins
• C.restricted and unrestricted built-ins only
• D.PL/SQL statements and unrestricted built-ins only

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?

• A.Add the code to handle the FORM_TRIGGER_FAILURE exception.
• B.Add code to handle the TOO_MANY_ROWS exception.
• C.Raise the TOO_MANY_ROWS exception.
• D.Code an On-Error trigger.
• E.Write a When-Validate-Item trigger for the Sales_Rep_Last_Name item.
• F.Change the form's validation Unit property to Record.
• G.Raise the FORM_TRIGGER_FAILURE exception.
• H.Code an On-Message trigger.
• I.Move the code to a form-level When-Validate-Item trigger.

You have been assigned to maintain the Orders form. Users complain that if the cursor is in the in the Orders block, they cannot navigate to the Order Items block by clicking a text item in that block. They must click the Next Block button to navigate from the Orders block to the Order Items block.
How should you investigate the source of the problem?

• A.Check the Navigation properties of the items in the Orders block that have non-default values.
• B.Check the Navigation properties of the form that have non-default values.
• C.Check that the items in the Order Items block are enabled.
• D.Check the Navigation properties of the Order Items block that have non-default values.
• E.Check the Pre-Text-Item and Post-Text-Item triggers, because users may be encountering a navigation trap.
• F.Check the Navigation properties of the Orders block that have non-default values.