View the Exhibit and examine the structure of the employees table.
Examine the following block of code:
What is the outcome when the above code is executed?
A.
It executes successfully.
B.
It gives an error because decode cannot be used in a PL/SQL block.
C.
It gives an error because the AVG function cannot be used in a PL/SQL block
D.
It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.
E.
It gives an error because both the AVG and decode functions cannot be used in a PL/SQL
block.
Explanation:
a
A
A
A
A