nerdexam
Oracle

1Z0-141 · Question #5

LibraryA and LibraryB are in the working directory of the Employees form. Library A is attached to the Employees form. There is a stored procedure in the database called Raise_Salary which must be…

The correct answer is C. first in the form module, then in the attached library, then in the database. See the full explanation below for the reasoning.

Question

LibraryA and LibraryB are in the working directory of the Employees form. Library A is attached to the Employees form. There is a stored procedure in the database called Raise_Salary which must be called without any parameters. There is no Raise_Salary procedure in the form or in the attached library. A When-Button-Pressed trigger in the Employees form contains this code:

raise_salary; Where does Forms search for the Raise_Salary procedure?

Options

  • Afirst in the attached library, then in the database
  • Bfirst in the form module, then in the attached library
  • Cfirst in the form module, then in the attached library, then in the database
  • Dfirst in the form module, then in the attached library, then in other libraries in the working
  • Ein the form module only
  • Fin the attached library only
  • Gin the database only

How the community answered

(37 responses)
  • A
    8% (3)
  • B
    14% (5)
  • C
    70% (26)
  • E
    5% (2)
  • G
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-141 Practice