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

Kaycee

1 months ago

Option E looks like it's trying to be too clever. Grouping by the COUNT(-) condition? That's just messy. Let's keep it simple, folks!

upvoted 0 times

Eleonore

6 days ago

B) I agree, simplicity is key when writing queries.

upvoted 0 times

...

Arlette

22 days ago

A) That's true, option E does seem overly complicated.

upvoted 0 times

...

Carey

1 months ago

Option D seems like it's on the right track, but the order of the clauses is a bit off. Shouldn't the WHERE clause come before the GROUP BY?

upvoted 0 times

Isreal

6 days ago

C) I agree, the order of the clauses in option D needs to be rearranged for the query to execute successfully.

upvoted 0 times

...

Glynda

7 days ago

B) Option D has the right idea, but the syntax needs to be adjusted for it to work properly.

upvoted 0 times

...

Gladys

9 days ago

A) That's correct, the WHERE clause should come before the GROUP BY in a SQL query.

upvoted 0 times

...

Theola

2 months ago

Haha, Option C is a bit of a mess. COUNT|prod_id>? What is that even supposed to mean? I think the correct function would be COUNT(prod_id).

upvoted 0 times

Dannie

13 days ago

I agree, the syntax in Option C is incorrect. It should be fixed to COUNT(prod_id) for clarity.

upvoted 0 times

...

Dannie

16 days ago

Option C is definitely confusing. It should be COUNT(prod_id) instead of COUNT|prod_id>.

upvoted 0 times

...

Domitila

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

Vicky

26 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

...

Malika

27 days ago

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

upvoted 0 times

...

Herman

28 days ago

D) SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

upvoted 0 times

...

Vanda

29 days ago

C) SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

upvoted 0 times

...

Edna

1 months ago

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

upvoted 0 times

...

Ryann

1 months ago

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

upvoted 0 times

...

Felicitas

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

...

Tijuana

1 months ago

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

upvoted 0 times

...

Mattie

2 months ago

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

upvoted 0 times

...

Danica

2 months ago

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

upvoted 0 times

...

Melda

2 months ago

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

upvoted 0 times

...

Kimberely

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

Sommer

29 days ago

C) SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

upvoted 0 times

...

Arminda

1 months ago

Yes, using COUNT(prod_id) instead of COUNT(-) would be more accurate.

upvoted 0 times

...

Micah

2 months ago

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

upvoted 0 times

...

Virgie

2 months ago

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

upvoted 0 times

...

Gail

2 months ago

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

upvoted 0 times

...

Danica

3 months ago

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

upvoted 0 times

...