What is the outcome when the code is executed?

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?

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.



Leave a Reply 11

Your email address will not be published. Required fields are marked *


Yogesh

Yogesh

A is right option.

Manuel

Manuel

La opción A es la correcta no hay errores de sintaxis, ni de ningun tipo dentro del bloque de código.

Luz REBOLLO

Luz REBOLLO

A is correct

Ahmed

Ahmed

A is correct
The best way is trying