Oracle Exam 1Z0-071 Topic 4 Question 115 Discussion

The NULLIF and COALESCE functions in Oracle SQL serve specific purposes:

Option A: Executes successfully. NULLIF returns NULL if the two arguments are equal; otherwise, it returns the first argument.

Option B: Also correct. COALESCE returns the first non-null value among its arguments.

Option C: This will not execute successfully because NULLIF requires both arguments to be of comparable data types. Comparing an integer to a character ('100' to 'A') is invalid.

Option D: Executes successfully. NULLIF returns NULL because it compares NULL to a number, which is valid (though always yields NULL).

Option E: Executes successfully. COALESCE accepts any data type as it returns the first non-null value, irrespective of type consistency among the arguments.