Oracle
1Z0-061 · Question #61
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…
The correct answer is C. The column alias should be replaced with the expression in the where clause. See the full explanation below for the reasoning.
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.
How the community answered
(24 responses)- A8% (2)
- B17% (4)
- C71% (17)
- D4% (1)
Community Discussion
No community discussion yet for this question.