表 TEACHER 包含如下字段：
列名 可为空否？ 数据类型
TEACHER_ID NOT NULL NUMBER(9)
NAME VARCHAR2(25)
SALARY NUMBER(7,2)
SUBJECT_ID NOT NULL NUMBER(3)
SUBJECT_DESCRIPTION VARCHAR2(2)
你需要将理科教师的工资上浮8%，理科教师的SUBJECT_ID是011，你需用哪一句实现? ( )
UPDATE teacher SET salary = salary * 1.08 WHERE subject_description LIKE ‘SCIENCE'
UPDATE teacher SET salary = salary * .08 WHERE subject_description LIKE 'SCIENCE' AND subject_id = 011
UPDATE teacher SET salary = salary * 1.08 WHERE subject_id = 011;
UPDATE teacher SET salary = salary + (salary * .08) WHERE subject_description LIKE 'SCIENCE' OR subject_id = 011
