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
Quick AnswerThe correct answer is You need to give the arithmetic expression in the SELECT clause, not the UPDATE clause. because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.