nerdexam
Oracle

1Z0-141 · Question #53

1Z0-141 Question #53: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-141 to reveal the answer and full explanation for question #53. The question stem and answer options stay visible for context.

Question

View the Exhibit. 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 these 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 Check Box and set other properties as shown in the exhibit, then run your form and insert three records: two with good credit and the check box clear, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set: CUST_ID LAST_NAME FIRST_NAME CREDIT_RATING --------- ---------- ----------- -------------- 1001 Gamer Pam 1002 Wallace Sheila 1003 Maslen Glenn Poor The first two records show an undetermined credit rating, although your intention was to set the value to Good for those customers. What change must you make in the properties of the Credit_Rating item to enable values of Good, Poor, and Null to be entered?

Exhibit

1Z0-141 question #53 exhibit

Options

  • AChange the Initial Value property to Good.
  • BChange the Check Box Mapping of Other Values property to Not Allowed.
  • CChange the Initial Value property to Good and the Value When Unchecked property to Null.
  • DChange the Initial Value property to Good and the Check Box Mapping of Other Values
  • EChange the Initial Value property to Good and the Check Box Mapping of Other Values
  • FChange the item type. It is not appropriate to use a check box to enable entry and update of

Unlock 1Z0-141 to see the answer

You've previewed enough free 1Z0-141 questions. Unlock 1Z0-141 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-141 Practice