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

Ariel

1 months ago

Haha, I almost selected D) because I thought it might be some kind of secret SQL ninja move. Glad I double-checked the options!

upvoted 0 times

...

Sanjuana

1 months ago

D) SELECT NULL := NULL? Really? What kind of sorcery is that? I'm just going to stick with the well-known NULL comparison options.

upvoted 0 times

Annamae

2 days ago

B) SELECT NULL <=> NULL; No, that one doesn't return true.

upvoted 0 times

...

William

3 days ago

C) SELECT NULL = NULL; This will not return true because NULL is not equal to NULL.

upvoted 0 times

...

Angelica

4 days ago

B) SELECT NULL <=> NULL; This is another way to compare NULL values.

upvoted 0 times

...

Leota

5 days ago

A) SELECT NULL <> NULL; That's the one that returns true.

upvoted 0 times

...

Ula

18 days ago

A) SELECT NULL <> NULL; That's the correct way to compare NULL values.

upvoted 0 times

...

Agustin

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

Carla

10 days ago

Yes, B is the correct answer because of the NULL equality operator.

upvoted 0 times

...

Latricia

19 days ago

I was also considering C, but B seems to be the right choice.

upvoted 0 times

...

Giuseppe

2 months ago

I agree, B is the one that returns true.

upvoted 0 times

...

Shawnda

2 months ago

I think B is the correct answer.

upvoted 0 times

...

Tegan

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

2 months ago

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

upvoted 0 times

...

Beckie

2 months ago

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

upvoted 0 times

...

Micaela

2 months ago

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

upvoted 0 times

...

Jill

2 months ago

Why do you think it's C?

upvoted 0 times

...

Victor

2 months ago

I disagree, I believe the answer is C.

upvoted 0 times

...

Jill

3 months ago

I think the answer is A.

upvoted 0 times

...