Oracle Exam 1Z0-082 Topic 1 Question 113 Discussion

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

Question #: 113
Topic #: 1

[All 1Z0-082 Questions]

Which two queries execute successfully?

ASELECT NULLIF(NULL, 100) FROM DUAL;

BSELECT COALESCE (100, 'AM FROM DUAL;

CSELECT 2TOLLIF(100, 'A') FROM DUAL;

DSELECT NULLIF(100,100) FROM DUAL;

ESELECT COALESCE(100, NULL, 200) FROM DUAL;

Show Suggested Answer

Suggested Answer: C

by Nenita at Mar 06, 2025, 03:02 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

1 days ago

I agree with you, Cecilia. NULLIF compares two expressions and returns NULL if they are equal, otherwise it returns the first expression.

upvoted 0 times

...

3 days ago

I think option D) SELECT NULLIF(100,100) FROM DUAL will execute successfully.

upvoted 0 times

...