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.
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.