View Exhibit1 and examine the structure of the employees table.
View Exhibit2 and examine the code.
What is the outcome when the code is executed?
A.
Both blocks compile and execute successfully when called.
B.
Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.
C.
The CALC_SAL procedure gives an error on compilation because the amt variable should be
declared in the RAISE_SALARY procedure.
D.
The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY
procedure cannot call the stand-alone increase function.
Explanation:
a
A
SEEMS A
BUT THERE IS A LOGICAL ERROR IN THE RESULT OF CALC_SAL PROCEDURE EXECUTION
MY OPINION IS
THAT ALWAYS YOU INCREASE AND UPDATE ONLY THE SALARU OF EMPLOYEE 120
NO USEFUL SEEMS THE PARAMETER.
SO IT SEEMS RIGHT B, BUT WITH THE TERM ERROR, I INTENDE THAT THE PROCEDURE CRASHES….
AND IT WON’T
A