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
sal+1000 calculates the incremented salary while selecting each employee name.