Online Access Free 1z1-151 Practice Test

View the exhibit.

In the OrderItemsForm, you have a control with a button that users can click to navigate to the first record in the block. The button has keyboard Navigable and Mouse Navigable set to No.
You are coding a When-Button-Pressed trigger for the First Record button with the following code:
SCROLL_UP;
WHILE FORM_SUCCESS LOOP
SCROLL_UP;
END LOOP;
What happens when the user clicks First Record with the cursor in the 72nd record in the block, as shown in the Exhibit?

• A.internal navigation to the first record occurs, but the visible cursor remains on record 72.
  You should add the SYNCHRONIZE command to synchronize the display with the internal state of the form.
• B.The form goes into an infinite loop and has to be killed by using operating system commands.
• C.Because there is no scroll bar, the cursor navigates only as far as the first visible record, which is record 63.
• D.The cursor successfully navigates to the first record.
• E.The display scrolls so that the first record is visible, bur the cursor stays on the last visible record, which should be record 10.
• F.A runtime error is encountered because there is no scroll bar for the block.

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

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

You add a display item named Quantity to the Order items block of your Orders form to display the quantity on hand for each product. Quantity is a non-base table item that should reflect the count of an ordered product from the inventories table.
What is the best way to populate the Order_Iterns.Quantity item?

• A.When New-Item-instance trigger
• B.Pre Query trigger
• C.Post-Query trigger
• D.When-New-Form-instance trigger
• E.You need to define a master-detail relation so that the item is populated automatically.

You create a Customers form by using wizards. When you test the form, you notice that you cannot the complete name that is displayed in the Customer_Name text item. Which three tools can you use to correct this problem?

• A.Property Palette
• B.Object Library
• C.Layout Editor
• D.Data Block wizard
• E.Layout wizard
• F.Object Navigator

The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.
You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.

You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:

The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?

• A.Change the Check Box Mapping of Other Values property to Not Allowed.
• B.Change the initial Value property to Good and the Value When Unchecked property to Null.
• C.Change the initial Value property to Good.
• D.Change the item type. It is not appropriate to use a check box to enable entry and update of more than two values in an item.
• E.Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.
• F.Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.