Oracle 1z0-144 Exam Practice Questions (P. 5)

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?

Which two statements are true about the continue statement? (Choose two.)

View the Exhibit and examine the code and its outcome on execution:

What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

View Exhibit 1 and examine the structure of the DO table.

View Exhibit 2 and examine the code.

The anonymous block gives an error on execution. What is the reason?

View the Exhibit and examine the structure of the departments table in SCOTTs schema.

Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS

BEGIN -
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)