Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

Oracle 1z0-151 Exam Actual Questions

The questions for 1z0-151 were last updated on May 1, 2024.
  • Viewing page 1 out of 23 pages.
  • Viewing questions 1-4 out of 90 questions

Topic 1 - Single Topic

Question #1 Topic 1

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 initial Value property to Good.
  • B. Change the Check Box Mapping of Other Values property to Not Allowed.
  • C. Change the initial Value property to Good and the Value When Unchecked property to Null.
  • D. Change the initial Value property to Good and the Chock Box Mapping of Other Valued property to Null.
  • E. Change the initial Value property to Good and the Check Box Mapping of Other Values property to checked.
  • F. 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.
Reveal Solution Hide Solution   Discussion  

Correct Answer: F 🗳️

Incorrect answers:
F: A check box is not limited to two values.

Question #2 Topic 1

When tabbing through items in the Employees form, users should not be able to navigate to the Salary text item. If they need to update the item, they will have to explicitly navigate to it by using the mouse.
Which property setting accomplishes this requirement?

  • A. Enabled = Yes; Keyboard Navigable = No
  • B. Enabled = No; Keyboard Navigable = Yes
  • C. Enabled = Yes; Keyboard Navigable = Yes
  • D. Enabled = No; Keyboard Navigable = No
  • E. Automatic Skip = Yes
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #3 Topic 1

You have a text item in your form named Object1. You want to create Object2 as an exact duplicate of Object1. You want to be able to change the properties of
Object2. However if you change Object1, you do not want Object2 to change.
Which method of reusing Object1 would be best for these requirements?

  • A. Copying Object1
  • B. Subclassing Object1
  • C. Creating a property class from Object1
  • D. Putting Object1 in an Object library
  • E. Referencing Object1 in a PL/SQL library
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #4 Topic 1

The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content canvas; the inventories block items are on the CV_inventories content canvas; and Control block buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing the stock of the selected product.
There is a button in the Control block with a When-Button-Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER' THEN
GO_BLOCK ('inventories')

ELSE -
GO_BLOCK('orders');
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the runtime error "FRM-41053: Cannot find Canvas: invalid ID." What should you do to correct this problem?

  • A. Change the sequence of blocks in the Object Navigator
  • B. Chang the Mouse Navigator property of the button to yes
  • C. in the first line of code, change the built-in to GET_ITEM_PROPERTY
  • D. in the first line of code, change the system variable to: SYSTEM.CURSOR_CANVAS.
  • E. in the first line of code, change the CV_ORDER to lowercase
  • F. Chang the argument to the GO_BLOCK built-ins to uppercase
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...