Oracle
1Z0-071 · Question #25
1Z0-071 Question #25: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
Question
See the Exhibit and examine the structure of the PROMOTIONS table: Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A. You issue the following SQL statements: What would be the outcome?
Exhibits
Options
- AIt generates an error because multiple conditions cannot be specified for the WHEN clause
- BIt executes successfully and gives the required result
- CIt generates an error because CASE cannot be used with group functions
- DIt generates an error because NULL cannot be specified as a return value
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.