题目：设关系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 Salary= Salary * 1.1 Where Teacher.D# = Dept. D# and Dept.Dname = '计算机';
C. Update Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname='计算机');
D. Update TABLE Teacher Set Salary = Salary * 1.1 Where Teacher.D# = Dept. D# and Dept.Dname = '计算机';
答案：评论后可见此内容
