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

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Kelvin

10 days ago

Wow, they really tried to trick us with some of these options. Good thing I know my SQL functions inside out!

upvoted 0 times

...

Refugia

11 days ago

D doesn't make sense, NULLIF() is supposed to return NULL if the two values are equal. That's just a waste of time.

upvoted 0 times

...

Jin

17 days ago

A and E work, because NULLIF() and COALESCE() handle NULL values correctly. B has a typo, and C is just nonsense.

upvoted 0 times

Leatha

6 days ago

A) SELECT NULLIF(NULL, 100) FROM DUAL;

upvoted 0 times

...

Cecilia

18 days ago

Exactly, Johana. That's why I think option D) is the correct answer.

upvoted 0 times

...

Johana

24 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

...

Cecilia

26 days ago

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

upvoted 0 times

...