Oracle
1Z0-061 · Question #26
1Z0-061 Question #26: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the data in the costs table. You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost. You issue the following query: Which statement is true regarding the above query?
Exhibit
Options
- AIt executes and produces the required result.
- BIt produces an error because an expression cannot be used in the order by clause.
- CIt produces an error because the DESC option cannot be used with an expression in the order by clause.
- DIt produces an error because the expression in the ORDER by clause should also be specified in the
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 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.