Oracle Exam 1Z0-071 Topic 10 Question 37 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 37
Topic #: 10

Which two are true about the NVL, NVL2, and COALESCE functions?

AThe first expression in NVL2 is never returned.

BNVL2 can have any number of expressions in the list.

CCOALESCE stops evaluating the list of expressions when it finds the first null value.

DCOALESCE stops evaluating the list of expressions when it finds the first non-null value.

ENVL must have expressions of the same data type.

FNVL can have any number of expressions in the list.

Show Suggested Answer

Suggested Answer: A, D

by Meaghan at May 03, 2022, 05:25 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!