Oracle Database SQL — Question 25

Which two statements are true? (Choose two.)

Answer options

• A. CASE is a function and DECODE is not.
• B. Neither CASE nor DECODE is a function.
• C. All conditions evaluated using CASE can also be evaluated using DECODE.
• D. All conditions evaluated using DECODE can also be evaluated using CASE.
• E. DECODE is a function and CASE is not.
• F. Both CASE and DECODE are functions.

Correct answer: D, E

Explanation

The correct answers are D and E because DECODE is indeed a function and all conditions that can be evaluated using DECODE can also be evaluated with CASE. Options A, B, C, and F are incorrect as they misrepresent the functionality of CASE and DECODE.