Refer table, structures given above. The 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 EMPLOYEE SET SALARY = SALARY * 1.20 WHERE DEPT NO. IN (SELECT DID FROM DEPARTMENT WHERE DNAME='SCIENCE');

(B) UPDATE TABLE EMPLOYEE SET SALARY = SALARY * 1.20 WHERE DNAME='SCIENCE';

(C) ALTER TABLE EMPLOYEE SET SALARY=SALARY * 1.20 WHERE DEPTNO. IN (SELECT DNAME FROM DEPARTMENT WHERE DNAME = 'SCIENCE')

1. A(A) and (B) only
2. B(A) only
3. C(B) and (C) only
4. D(C) only

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: B. (A) only

Explanation

Only A is valid: update EMPLOYEE where DEPTNO is in the SCIENCE department's DID. B uses invalid syntax (UPDATE TABLE) and a column EMPLOYEE lacks; C uses ALTER instead of UPDATE.