View the Exhibit and examine the structure of the customer table.Examine the following trigger code:What is the outcome when the above trigger is compiled?
Which statements are true about PL/SQL procedures? (Choose all that apply.)
The STRING_TAB table has the following structure:View the Exhibit and examine the code.What is the outcome on execution?
Identify two situations where the DBMS_SQL package should be used. (Choose two.)
View the Exhibit and examine the code.Why does the code give an error on execution?
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?
