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.
A is correct. Syntax-wise it will execute, During runtime it may fail due to lack of exception handling, incase value is not found.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
maabreh
2 years, 1 month agoNaveen_2022
2 years, 6 months ago