Oracle 1z1-151 Value Pack (Frequently Bought Together)

View the Exhibit.

What four facts can you determine by examining the Object Navigator?

• A. You can delete an order without deleting its order items.
• B. The Orders block is a detail block.
• C. An order can be deleted only if it has no order items.
• D. The Order_Items block is a master block.
• E. The Orders block is a master block.
• F. The Order_Items block is a detail block.
• G. If an order is deleted, all of its order items are deleted.
• H. The inventories block is a master block.
• I. You cannot delete order items without deleting the order.
• J. If you delete an order item, all of its associated inventory items are deleted.

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

The Enforce Primary Key property of a data block ensures that the primary key of a new record exists in the database.

• A. False
• B. True

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. 8, 3, 6, 5, 4, 7, 1, 2
• B. 7, 1, 3, 6, 5, 1, 8, 4
• C. 3, 6, 5, 7, 8, 1, 2, 4
• D. 5, 3, 6, 7, 1, 8, 2, 4

Which three are valid ways to populate a display item?

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