Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 116

Which two statements are true? (Choose two.)

    Correct Answer: D, E

    DECODE is indeed a function in Oracle SQL, whereas CASE is an expression, not a function. Additionally, all conditions that can be evaluated using DECODE can also be evaluated using CASE. This makes both statements true.

Discussion
dexdinh91Options: DE

DE are correct

lucemqyOptions: DE

DE Case is a statement DECODE is a function

zouve

case is statement while decode is a function

Babi265Options: DE

Should be DE ?

WingLOptions: DF

DE are correct. CASE is a expression not a function. https://docs.oracle.com/cd/B13789_01/appdev.101/b10807/13_elems004.htm#:~:text=The%20CASE%20statement%20evaluates%20a,first%20one%20that%20is%20TRUE%20.

Viviana3184Options: DE

DE are correct