What is the reason for the error?

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.
SQL>SELECT prod_name, prod_list_price,
prod_list_price – (prod_list_price * .25) “DISCOUNTED_PRICE”
FROM products
WHERE discounted_price < 10;
The query generates an error.

What is the reason for the error?

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.

SQL>SELECT prod_name, prod_list_price,
prod_list_price – (prod_list_price * .25) “DISCOUNTED_PRICE”
FROM products
WHERE discounted_price < 10;
The query generates an error.

What is the reason for the error?

A.
The parenthesis should be added to enclose the entire expression.

B.
The double quotation marks should be removed from the column alias.

C.
The column alias should be replaced with the expression in the WHERE clause.

D.
The column alias should be put in uppercase and enclosed with in double quotation marks in the WHERE clause.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Surendar

Surendar

Option D is the correct answer

Justyna

Justyna

You cannot use column alias in ‘Where’ clause of select statement.

select deptno “Department”
from dept
where “Department”=10

ORA-00904: “Department”: invalid identifier
00904. 00000 – “%s: invalid identifier”
*Cause:
*Action:
Error at Line: 3 Column: 7

Surendar

Surendar

can you try with the uppercase letter? ie “DEPARTMENT”

Surendar

Surendar

select deptno “DEPARTMENT”
from dept
where “DEPARTMENT”=10

Surendar

Surendar

I agree its not possible.

Tom

Tom

C is the only correct answer.