 
			 
			MCQOPTIONS
 Saved Bookmarks
				| 1. | Given below are two statements to find the sum of salaries of all employees of the English department as well as the maximum. minimum and average salary in English department.STATEMENT I: SELECT SUM (SALARY). MAX (SALARY), MIN (SALARY).AVG (SALARY) FROM EMPLOYEE, DEPARTMENTWHERE DEPTNO=DIDAND DNAME='ENGLISH';STATEMENT II: SELECT SUM (SALARY), MAX (SALARY), MIN (SALARY),AVG (SALARY) FROM EMPLOYEE, DEPARTMENTWHERE DNAME='ENGLISH';In the light of the above statements, choose the correct answer from the options given below | 
| A. | Both Statement I and Statement II are true | 
| B. | Both Statement I and Statement II are false | 
| C. | Statement I is correct but Statement II is false | 
| D. | Statement I is incorrect but Statement II is true | 
| Answer» D. Statement I is incorrect but Statement II is true | |