Oracle
1Z0-144 · Question #50
1Z0-144 Question #50: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-144 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
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
Unlock 1Z0-144 to see the answer
You've previewed enough free 1Z0-144 questions. Unlock 1Z0-144 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.