Examice

Exam 1z0-082 All QuestionsBrowse all questions from this exam

Go to Exam

Question 135

The sales table has columns PROD_ID and QUANTITY_SOLD of data type number.

Which two queries execute successfully? (Choose two.)

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

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

SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) > 10;

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

SELECT prcd_id FROM sales WHERE quantity_sold > 55000 AND COUNT (*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;

Correct Answer: A, D

Two queries execute successfully. One query is to count the number of prod_id from the sales table where the quantity_sold is greater than 55000, grouping the results by prod_id. The other query selects prod_id from the sales table where quantity_sold is greater than 55000, grouping by prod_id and including only those groups having a count greater than 10. These queries are syntactically correct and logically structured for the given scenario.

Discussion

Oracle2020Options: AD

I AGREE AD

Darkseid1231Options: AD

A D is correct