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 UPDATE clause.
B
You need to give the arithmetic expression that involves the salary increment in the UPDATE 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 UPDATE clause.
Explanation
To preview salary increments, use arithmetic in the SELECT clause: SELECT salary + 100 FROM employee;