nerdexam
Oracle

1Z0-141 · Question #124

You are designing a Human Resources application that uses a menu to implement most of the code. One of the menu items is labeled Raise Salary. The business rule is that the salary should be raised…

The correct answer is C. IF NAME_IN('EMPLOYEES.SALARY') < 25000 THEN. See the full explanation below for the reasoning.

Question

You are designing a Human Resources application that uses a menu to implement most of the code. One of the menu items is labeled Raise Salary. The business rule is that the salary should be raised 2% if the salary of the selected employee shown in the form is less than $25,000 per year, but the raise should be 3% if the value of the salary item is $25,000 or greater. Which condition can you use in the menu code to determine if the current value of the Salary item in the Employees block is less than $25,000?

Options

  • AIF :EMPLOYEES.SALARY < 25000 THEN...
  • BIF COPY('EMPLOYEES.SALARY') < 25000 THEN...
  • CIF NAME_IN('EMPLOYEES.SALARY') < 25000 THEN...
  • DIF FIND_ITEM('EMPLOYEES.SALARY') < 25000 THEN...
  • EIF GET_ITEM_PROPERTY('EMPLOYEES.SALARY',DATABASE_VALUE) < 25000 THEN...

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    7% (2)
  • C
    70% (21)
  • D
    17% (5)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-141 Practice