nerdexam
Oracle

1Z0-144 · Question #50

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database. SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger…

The correct answer is A. Only HR. See the full explanation below for the reasoning.

Question

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database. SCOTT creates the following trigger:

CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA BEGIN RAISE_APPLICATION_ERROR (-20000, `Cannot drop object'); END:

SCOTT does not grant the execute privilege on this trigger to any other users. For which user(s) would this trigger fire by default when they drop an object in the hr schema?

Options

  • AOnly HR
  • BSCOTT and HR
  • COnly SCOTT
  • DSCOTT, HR, and SYS

How the community answered

(45 responses)
  • A
    76% (34)
  • B
    7% (3)
  • C
    4% (2)
  • D
    13% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice