有SQL语句： UPDATE examiner SET ersalary=ersalary*1.05 WHERE erdepa='信息学院'AND ersalary＜（select avg（ersalary） from examiner）；＞

中T#教师编号,Tname教师姓名,D#系号,Salary工资。 Dept(D# char(2),Dname char(10),Dean char(10)),Dname系名,Dean系主任。 若要将所有计算机系的教师工资上调10%,则可用（ ）。

A、Update Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname =’计算机’);

B、Update Salary= Salary * 1.1 Where Teacher.D# = Dept. D# and Dept.Dname = ’计算机’;

C、Update TABLE Teacher Set Salary = Salary * 1.1 Where Teacher.D# = Dept. D# and Dept.Dname = ’计算机’;

D、Update Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname=’计算机’);

中T#教师编号，Tname教师姓名，D#系号，Salary工资。Dept（D# char(2),Dname char(10),Dean char(10)),Dname系名，Dean系主任。若要将所有计算机系的教师工资上调10%，则可用（）

A、Update Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname=’计算机’);

B、Update Salary = Salary * 1.1 Where D# in (Select D# From Dept Where Dname = 计算机);

C、Update TABLE Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname = ’计算机’);

D、Update Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname =’计算机’);

A、

B、

C、

D、

E、

F、

G、

A、

B、

C、

D、

E、

F、

G、

中T#教师编号，Tname教师姓名，D#系号，Salary工资。Dept（D# char(2),Dname char(10),Dean char(10)),Dname系名，Dean系主任。若要将所有计算机系的教师工资上调10%，则可用_________。

A、Update Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname=‘计算机’);

B、Update Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname =‘计算机’);

C、Update Salary = Salary * 1.1 Where D# in (Select D# From Dept Where Dname = 计算机);

D、Update TABLE Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname = ‘计算机’);

YouareworkingasaDBAatNetFxCorporation.Auser，Scott，ismaintainingtherecordsofalltheemployeesintheEMPLOYEEtable.Initially，thesalaryoftheemployee，’E0025’，was$1800.On1May2004，thesalaryoftheemployee，’E0025’，wasincreasedby$200.

Theuser，Scott，issuedthefollowingstatementtomodifytherecordoftheemployee，’E0025’：

SQL>UPDATEEMPLOYEESETSALARY=2000

WHEREEMPNO=’E0025’；

SQL>COMMIT；

OnDecember1，2004，thesalaryoftheemployee，’E0025’，wasincreasedby$400.Theuser，Scott，issuedthefollowingstatementtomodifytherecordoftheemployee，’E0025’：

SQL>UPDATEEMPLOYEESETSALARY=2400

WHEREEMPNO=’E0025’；

SQL>COMMIT；

OnJuly1，2005，thesalaryoftheemployee，’E0025’，wasincreasedby$500.Theuser，Scott，issuedthefollowingstatementtomodifytherecordoftheemployee，’E0025’

SQL>UPDATEEMPLOYEESETSALARY=2900

WHEREEMPNO=’E0025’；

SQL>COMMIT；

OnJuly5，2005，theHRmanageraskedyoutogeneratetheincrementreportoftheemployee，’E0025’，fortheperiodbetween1May2004and1July2005.Whichflashbackfeaturewillyouusetogeneratetheincrementreport？（）

设关系Teacher的结构为：Teacher（T# char(3), Tname char(10), D# char(2), Salary float(2))，其中T#教师编号，Tname教师姓名，D#系号，Salary工资。Dept（D# char(2),Dname char(10),Dean char(10)),Dname系名，Dean系主任。若要将所有计算机系的教师工资上调10%，则可用_________。 A.Update TABLE Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname = ‘计算机’); B.Update Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname =‘计算机’); C.Update Salary = Salary * 1.1 Where D# in (Select D# From Dept Where Dname = 计算机); D.Update Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname=‘计算机’);