Oracle Exam 1Z0-082 Topic 13 Question 83 Discussion

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

Question #: 83
Topic #: 13

[All 1Z0-082 Questions]

The sales table has columns prod_id and quantity_sold of data type number

In two queries execute successfully? x

ASELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

BSELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;

CSELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

DSELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

ESELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;

Show Suggested Answer

Suggested Answer: E, F

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm

by Stephen at Dec 12, 2023, 02:08 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Domitila

13 days ago

Option B is interesting, but the syntax seems a bit off. Shouldn't we have the COUNT(-) condition in the HAVING clause instead of the WHERE clause?

upvoted 0 times

...

Danica

19 days ago

Hmm, you might be right. Let's analyze the queries further before making a final decision.

upvoted 0 times

...

Melda

21 days ago

I disagree, I believe option B is the right choice as it includes both quantity_sold and COUNT(-) conditions.

upvoted 0 times

...

Kimberely

22 days ago

Option A looks promising, but I'm not sure if the COUNT(-) is the right way to count the number of records. Shouldn't we use COUNT(prod_id) instead?

upvoted 0 times

Virgie

2 days ago

I think you're right, we should use COUNT(prod_id) to count the number of records.

upvoted 0 times

...

Gail

9 days ago

A) SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

upvoted 0 times

...

Danica

27 days ago

I think option A is correct because it groups by prod_id and filters by quantity_sold.

upvoted 0 times

...