Which query displays employee names and the new salary after an increment of Rs. 1000?
Answer options
A
SELECT ename, sal FROM emp
B
SELECT ename, sal+1000 FROM emp
C
SELECT ename, 1000 FROM emp
D
SELECT * FROM employee
Correct answer: SELECT ename, sal+1000 FROM emp
Explanation
Quick AnswerThe correct answer is SELECT ename, sal+1000 FROM emp because it directly addresses the core logic of Practice Set 1.
sal+1000 calculates the incremented salary while selecting each employee name.