Oracle
1Z0-047 · Question #63
1Z0-047 Question #63: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #63. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the description of the ORDER_ITEMS table. The following SQL statement was written to retrieve the rows for the PRODUCT_ID that has a UNIT_PRICE of more than 1,000 and has been ordered more than five times: SELECT product_id, COUNT(order_id) total, unit_price FROM order_items WHERE unit_price>1000 AND COUNT(order_id)>5 GROUP BY product_id, unit_price; Which statement is true regarding this SQL statement?
Exhibit
Options
- AThe statement would execute and give you the desired result.
- BThe statement would not execute because the aggregate function is used in the WHERE clause.
- CThe statement would not execute because the WHERE clause should have the OR logical operator
- DThe statement would not execute because in the SELECT clause, the UNIT_PRICE column is
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.