nerdexam
Oracle

1Z0-151 · Question #11

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…

The correct answer is B. Set the Mapping of Other Values property for the list item. The important property is the "mapping of other values." This property tells Oracle Forms how to handle values that are not expected.

Design Considerations for PL/SQL Code

Question

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?

Options

  • AEnsure that required is set to No for the list item so that a blank line appears in the list.
  • BSet the Mapping of Other Values property for the list item.
  • CSet the Default Value property for the list item.
  • DSet the Query Allowed Property for the list Item.
  • EUsers must re-enter the records for those customers that cannot be accessed.

How the community answered

(21 responses)
  • A
    5% (1)
  • B
    71% (15)
  • D
    5% (1)
  • E
    19% (4)

Explanation

The important property is the "mapping of other values." This property tells Oracle Forms how to handle values that are not expected.

Topics

#static list item#Mapping of Other Values#legacy data#data validation

Community Discussion

No community discussion yet for this question.

Full 1Z0-151 Practice