Exam 1z0-071 topic 1 question 73 discussion

Actual exam question from Oracle's 1z0-071

Question #: 73
Topic #: 1

Examine the description of the EMPLOYEES table:

Which statement will execute successfully, returning distinct employees with non-null first names?

A. SELECT first_name, DISTINCT last_name FROM employees WHERE first_name <> NULL;
B. SELECT first_name, DISTINCT last_name FROM employees WHERE first_name IS NOT NULL;
C. SELECT DISTINCT * FROM employees WHERE first_name IS NOT NULL;
D. SELECT DISTINCT * FROM employees WHERE first_name <> NULL;

Show Suggested Answer

Suggested Answer: C 🗳️

by CyberP at May 27, 2023, 12:33 p.m.

Submit Cancel

2 months ago

Selected Answer: C

Not valid to compare NULL to any value must use IS NOT NULL or IS NULL

upvoted 2 times

...

2 months, 4 weeks ago

Selected Answer: C

C is OK, last comment was a mistake.

upvoted 2 times

...

2 months, 4 weeks ago

Selected Answer: A

AD are the correct answers

upvoted 1 times

1 month, 1 week ago

do you think you can get rows with this expression first_name <> NULL ?

upvoted 1 times

...

7 months, 3 weeks ago

Distinct should come first after select, also we use is not null so it is C.

upvoted 2 times

...