Refer table, structures given above, University decided to give all employees in the ‘SCIENCE’ department a 20% rise in salary. Which of the following query/queries will compute the above results?(A)UPDATE EMPLOYEESET SALARY = SALARY*1.20WHERE DEPT NO. IN (SELECT DID FROM DEPARTMENT WHERE DNAME='SCIENCE');(B)UPDATE TABLE EMPLOYEESET SALARY = SALARY*1.20WHERE DNAME='SCIENCE’;(C)ALTER TABLE EMPLOYEESET SALARY=SALARY*1.20WHERE DEPTNO. IN (SELECT DNAME FROM DEPARTMENT WHERE DNAME ='SCIENCE’)Choose the correct answer from the options given below:

Refer table, structures given above, University decided to give all em

1.	Refer table, structures given above, University decided to give all employees in the ‘SCIENCE’ department a 20% rise in salary. Which of the following query/queries will compute the above results?(A)UPDATE EMPLOYEESET SALARY = SALARY1.20WHERE DEPT NO. IN (SELECT DID FROM DEPARTMENT WHERE DNAME='SCIENCE');(B)UPDATE TABLE EMPLOYEESET SALARY = SALARY1.20WHERE DNAME='SCIENCE’;(C)ALTER TABLE EMPLOYEESET SALARY=SALARY*1.20WHERE DEPTNO. IN (SELECT DNAME FROM DEPARTMENT WHERE DNAME ='SCIENCE’)Choose the correct answer from the options given below:
A.	(A) and (B) only
B.	(A) only
C.	(B) and (C) only
D.	(C) only
Answer» B. (A) only