

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 | |