View the Exhibit to examine the PL/SQL block.Which statement is true about the execution of the PL/SQL block?
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_triggerBEFORE 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 to examine the PL/SQL code:DECLARE -x NUMBER := 5;y NUMBER := NULL;BEGIN -IF x != y THEN yields NULL, not TRUEDBMS_OUTPUT.PUT_LINE(x != y); not runELSIF x = y THEN also yields NULLDBMS_OUTPUT.PUT_LINE(x = y);ELSE -DBMS_OUTPUT.PUT_LINE -(Cant tell if x and y are equal or not.);END IF;END;/SREVROUPUT is on for the session. Which statement is true about the output of the PL/SQL block?
