HOW MANY ROWS OF DATA ARE RETURNED AFTER EXECUTING THE FOLLOWING S...
10. How many rows of data are returned after executing the following statement?SELECT DEPT_ID, SUM(SALARY) FROM EMP GROUP BY DEPT_ID HAVING SUM(NVL(SALARY,100)) > 400;Assume the EMP table has ten rows and each contains a SALARY value of 100, except for one, which has a null value in the SALARY field. The first five rows have a DEPT_ID value of 10, while the second five rows, which include the row with a null SALARY value, have a DEPT_ID value of 20. (Choose the best answer.) A. Two rows B. One row C. Zero rows D. None of the above