Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)
In which of the following scenarios would you recommend using PL/SQL records?
View the Exhibit and examine the structure of the employees table.Execute the following block of code:What is the outcome?
Examine the following snippet of PL/SQL code:View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ST_CLERK and salary greater than 3000.
View the exhibit and examine the structure of the EMPLOYEES table.The salary of EMPLOYEE_ID 195 is 2800.You execute the following code:What is the outcome?
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?
