What is the outcome when the above code is executed?

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?

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.



Leave a Reply 2

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