设关系Teacher的结构为：Teacher（T# char(3), Tname char(10), D# char(2), Salary float(2))，其中T#教师编号，Tname教师姓名，D#系号，Salary工资。Dept（D# char(2)

题目：设关系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 Salary = Salary * 1.1 Where D# in (Select D# From Dept Where Dname = 计算机);

B. Update Teacher Set 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 = ‘计算机’);

答案：评论后可见此内容