Question: What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP;

Answer: This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary.