Oracle Exam 1Z0-071 Topic 5 Question 100 Discussion

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

Question #: 100
Topic #: 5

[All 1Z0-071 Questions]

Examine the description of the EMPLOYEES table:

Which statement will fail?

ASELECT department_id, COUNT (*)
FROM employees
HAVING department_ id <> 90 AND COUNT(*) >= 3
GROUP BY department_id;

BSELECT department_id, COUNT (*)
FROM employees
WHERE department_ id <> 90 AND COUNT(*) >= 3
GROUP BY department_id;

CSELECT department_id, COUNT(*)
FROM employees
WHERE department_id <> 90 HAVING COUNT(*) >= 3
GROUP BY department_id;

DSELECT department_id, COUNT(*)
FROM employees
WHERE department_id <> 90 GROUP BY department_id
HAVING COUNT(*) >= 3;

Show Suggested Answer

Suggested Answer: D, E

by Daniela at Aug 28, 2024, 09:28 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Tenesha

9 days ago

Option C is just a mess. Mixing the WHERE and HAVING clauses like that is a recipe for disaster.

upvoted 0 times

...

Farrah

9 days ago

Option D is the way to go! Putting the HAVING clause after the GROUP BY makes the most sense to me.

upvoted 0 times

...

Gracia

14 days ago

Option B looks like it might work, but the WHERE clause and HAVING clause are a bit confusing. I'll have to think about that one.

upvoted 0 times

...

Kristian

21 days ago

Option A seems a bit odd, using HAVING in the wrong place. I'm guessing that one will fail.

upvoted 0 times

...

Gilma

23 days ago

I believe option D will fail because the HAVING clause should come after the GROUP BY clause.

upvoted 0 times

...

Shala

24 days ago

I agree with Magdalene. Option A seems incorrect due to the placement of the HAVING clause.

upvoted 0 times

...

Magdalene

27 days ago

I think option A will fail because HAVING clause should be after GROUP BY.

upvoted 0 times

...