Exam 1z0-071 Topic 4 Question 326 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 326
Topic #: 4
View the Exhibit and examine the structure of the PRODUCTS table. (Choose the best answer.)

You must display the category with the maximum number of items.
You issue this query:
SQL > SELECT COUNT(*), prod_category_id
FROM products
GROUP BY prod_category_id
HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM porducts);
What is the result?

Suggested Answer: D Vote an answer

by Harlan at Nov 21, 2026, 07:10 PM

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

0
0
0
10