nerdexam
Oracle

1Z0-141 · Question #107

To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from form triggers or menu items. You need to populate some fields based…

The correct answer is E. IF NAME_IN('ORDERS.order_total') > 10000. See the full explanation below for the reasoning.

Question

To centralize some of your processing, you decide to write PL/SQL library modules that contain procedures that can be called from form triggers or menu items. You need to populate some fields based on values in other fields. Which code do you use?

Options

  • AIF FIND_ITEM('ORDERS.order_total') > 10000
  • BIF :ORDERS.order_total > 10000
  • CIF 'ORDERS.order_total' > 10000
  • DIF :ORDERS.order_total > 10000
  • EIF NAME_IN('ORDERS.order_total') > 10000

How the community answered

(43 responses)
  • B
    7% (3)
  • C
    5% (2)
  • D
    14% (6)
  • E
    74% (32)

Community Discussion

No community discussion yet for this question.

Full 1Z0-141 Practice