Oracle
1Z0-061 · Question #61
1Z0-061 Question #61: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #61. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the products table. Using the products table, you issue the following query to generate the names, current list price, and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it. The query generates an error. What is the reason for the error?
Exhibit
Options
- AThe parenthesis should be added to enclose the entire expression.
- BThe double quotation marks should be removed from the column alias.
- CThe column alias should be replaced with the expression in the where clause.
- DThe column alias should be put in uppercase and enclosed within double quotation marks in the where clause.
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.