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;