nerdexam
Oracle

1Z0-147 · Question #24

Why do you use an INSTEAD OF trigger?

The correct answer is D. to modify data in which the DML statement has been issued against an inherently non-updateable view. See the full explanation below for the reasoning.

Question

Why do you use an INSTEAD OF trigger?

Options

  • Ato perform clean up actions when ending a user session
  • Bto insert data into a view that normally does not accept inserts
  • Cto insert into an audit table when data is updated in a sensitive column
  • Dto modify data in which the DML statement has been issued against an inherently non-updateable view

How the community answered

(33 responses)
  • A
    3% (1)
  • B
    6% (2)
  • C
    12% (4)
  • D
    79% (26)

Community Discussion

No community discussion yet for this question.

Full 1Z0-147 Practice