TEACHER(讲师)表中列的定义如下：
Name Null Type
-------------------- ---------------- -----------------
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，应使用如下的哪个语句
A．UPDATE teacher
SET salary=salary * 1.08
WHERE subject_description LIKE ’SCIENCE’;
B．UPDATE teacher
SET salary=salary * .08
WHERE subject_description LIKE ’SCIENCE’
AND subject_id=011;
C．UPDATE teacher
SET salary=salary * 1.08
WHERE subject_id=011;
D．UPDATE teacher
SET salary=salary+(salary * .08)
WHERE subject_description LIKE ’SCIENCE’
OR subject_id=011;
