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?
A.
It gives an error because only the innermost block is labeled
B.
It gives an error because the same variable name cannot be used across all the nested blocks.
C.
It executes successfully and displays the resultant values in the following sequence- 1000, 2800 50000, 2800.
D.
It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000.
C is correct.
C for sure…
C
C is correct
C,
First dbms is 1000, then value 2800 on line 8 was selected into v_sal and outputted, inner block within lines 10-14 shows that v_sal was assigned to 50000 and outputted via dbms_output on line 13, output on line 15 is equal to output on line 9, because there is no other assignation between lines 9 and 14 within inner block 7-16 .