Oracle Exam 1Z0-909 Topic 9 Question 30 Discussion

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

Question #: 30
Topic #: 9

[All 1Z0-909 Questions]

Which select statement returns true?

ASELECT NULL <> NULL;

BSELECT NULL <=> NULL;

CSELECT NULL = NULL;

DSELECT NULL := NULL;

Show Suggested Answer

Suggested Answer: B, C

by Gail at Jan 24, 2024, 10:24 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Agustin

9 days ago

I was torn between B and C, but B makes the most sense since the NULL equality operator <=> is specifically designed to handle NULL comparisons.

upvoted 0 times

Shawnda

17 hours ago

I think B is the correct answer.

upvoted 0 times

...

Tegan

10 days ago

The correct answer is B) SELECT NULL <=> NULL. This is the only statement that returns true when comparing two NULL values.

upvoted 0 times

...

Micaela

12 days ago

But NULL is not equal to NULL, so I think A) is the correct answer.

upvoted 0 times

...

Beckie

13 days ago

I disagree, I believe the correct answer is C) SELECT NULL = NULL.

upvoted 0 times

...

Micaela

15 days ago

I think the answer is A) SELECT NULL <> NULL.

upvoted 0 times

...

Jill

17 days ago

Why do you think it's C?

upvoted 0 times

...

Victor

18 days ago

I disagree, I believe the answer is C.

upvoted 0 times

...

Jill

28 days ago

I think the answer is A.

upvoted 0 times

...