ABC company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification. If you do not want to store the results in the database, which statement is valid?
Answer options
A
You need to give the arithmetic expression in the SELECT clause, not the DISPLAY clause.
B
You need to give the arithmetic expression that involves the salary increment in the DISPLAY clause.
C
The query is correct as written.
D
You need to use a subquery to add $100 to the salary.
Correct answer: You need to give the arithmetic expression in the SELECT clause, not the DISPLAY clause.
Explanation
The correct clause to calculate salary + 100 for display is SELECT, not DISPLAY.