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

Yolande

1 months ago

I'm just gonna go with A and E. Anything involving NULLIF() or COALESCE() is usually a safe bet.

upvoted 0 times

Dominga

3 days ago

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

upvoted 0 times

...

Delisa

2 months ago

Hmm, B looks a bit iffy, but I think I can figure it out. Time to put my SQL skills to the test!

upvoted 0 times

Tenesha

9 days ago

I think A and D are the queries that will execute successfully.

upvoted 0 times

...

Lashawn

10 days ago

E) SELECT COALESCE(100, NULL, 200) FROM DUAL;

upvoted 0 times

...

Jin

12 days ago

D) SELECT NULLIF(100,100) FROM DUAL;

upvoted 0 times

...

Lorrie

15 days ago

C) SELECT 2TOLLIF(100, 'A') FROM DUAL;

upvoted 0 times

...

Keshia

19 days ago

B) SELECT COALESCE (100, 'AM FROM DUAL;

upvoted 0 times

...

Cornell

23 days ago

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

upvoted 0 times

...

Kelvin

2 months 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

Geoffrey

5 days ago

Yes, COALESCE function can handle different data types and return the first non-null value.

upvoted 0 times

...

Reed

6 days ago

I believe option B) SELECT COALESCE (100, 'AM FROM DUAL; also executes successfully.

upvoted 0 times

...

Filiberto

1 months ago

I agree, that one should work without any issues.

upvoted 0 times

...

Rosalyn

1 months ago

I think option D) SELECT NULLIF(100,100) FROM DUAL; executes successfully.

upvoted 0 times

...

King

1 months ago

User 2: D) SELECT NULLIF(100,100) FROM DUAL; also executes successfully.

upvoted 0 times

...

Jestine

1 months ago

User 1: A) SELECT NULLIF(NULL, 100) FROM DUAL; executes successfully.

upvoted 0 times

...

Refugia

2 months 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

2 months 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

Dorian

28 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

...

Corinne

1 months ago

E) SELECT COALESCE(100, NULL, 200) FROM DUAL;

upvoted 0 times

...

Vincenza

1 months ago

D) SELECT NULLIF(100,100) FROM DUAL;

upvoted 0 times

...

Thurman

1 months ago

C) SELECT 2TOLLIF(100, 'A') FROM DUAL;

upvoted 0 times

...

Deandrea

1 months ago

B) SELECT COALESCE (100, 'AM FROM DUAL;

upvoted 0 times

...

Leatha

2 months ago

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

upvoted 0 times

...

Cecilia

2 months ago

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

upvoted 0 times

...

Johana

2 months 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

3 months ago

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

upvoted 0 times

...