Free Oracle 1z1-151 Exam Dumps Questions & Answers

Customers log in to your Orders application by using their customer ID, which is saved as a global variable. When the Orders form first comes up, you want it to be populated with the customer's orders, and you do not want customers to be able to query for another customer's orders.
You code the following triggers:
When-New Form instance on the Orders form:
GO_BLOCK('orders');
EXECUTE_QUERY;
You also have a button in the Control block labeled Query Orders with a When-Button Pressed trigger that has the same code as the When New-Form instance trigger.
To test the form, you run it and log in a Customer 104. When you click Query Orders, all orders are shown, not just those for Customer 104.
What is the best way to correct this issue to ensure that the customer can never query another customer's orders?

• A.  Delete the Key-Exqry trigger and put its code in a Pre-Query trigger.
• B.  Change the last line of the When-Button-Pressed code to:
  DO_KEY ('EXECUTE_QUERY');
• C.  Delete the Key-Exeqry trigger and add the its first line after the call to GO_BLOCK in the When-New-Form-instance trigger.
• D.  Delete the Key-Exqry trigger and put its code in an On-Select trigger.

View the Exhibit.

Iin the Human Resources form shown in the Exhibit, you want to modify the prompts, heights, and widths of the Department Id, Manager Id, and Location Id Holds in the Departments data block.
What must you select before invoking the Layout Wizard in reentrant mode to modify these item properties?

• A.  Frames
• B.  the DEPARTMENT_ID, MANAGER_ID and LOCATION_ID items
• C.  Frame5
• D.  the Departments block
• E.  Canvas4

A clerk is using the Human Resources form, which displays a department and its associated employees on the same canvas. Only two Items in the form are enabled.
Possible navigation units that can occur during navigation of this form are:
1. Outside the form
2. The Human Resources form
3. The Departments block
4. The Employees block
5. The current Departments record
6. The current Employees record
7. The Department_Id item
8. The Employee_Id item
With the cursor in : Departments.Department_Id, the clerk clicks the
:Employees.Employee_Id item.
What is the sequence of navigational unit movement that occurs?

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

You have been assigned to maintain a Forms application that was designed by a developer who has left the company.
The CV_Tools canvas contains several buttons. There is limited space on the canvas, but the first button is not quite wide enough to display its complete label. In the Layout Editor, you widen the button slightly and find that the width of all the buttons increases so that they now overlap each other.
What could have caused this problem?

• A.  All other buttons were subclassed from the first button.
• B.  All other buttons were copied from the first button.
• C.  The buttons were created by using a Smart Class.
• D.  The first button was subclassed from another button.
• E.  The buttons were created by dragging them from an object group.
• F.  The buttons inherit their properties from the same property class.
• G.  The first button was copied from another button.

View the Exhibit.

You have just created a new object library as shown in the Exhibit. You want the tabs to have descriptive names.
You cannot change the names of the default object library tabs, so you must create new tabs in order to have descriptive names.

• A.  True
• B.  False