F. SELECT INTO G. FETCH INTO H. =
71. 你需要将所属部门名称为“SALES”的所有员工的工资增加10%，你需用哪一句实现? (选择1项)
E. UPDATE emp SET sal = sal * 1.1 WHERE dname LIKE 'SALES' ;
F. UPDATE emp SET sal = sal * 1.1 WHERE deptno =(SELECT deptno FROM
emp WHERE dname LIKE 'SALES' );
G. UPDATE emp SET sal = sal * 1.1 WHERE dname =(SELECT deptno FROM
emp WHERE dname LIKE 'SALES' );
H. UPDATE emp SET sal = sal * 1.1 WHERE deptno =(SELECT dname FROM
emp WHERE dname LIKE 'SALES' )
72.当下列语句执行完后，X的值是多少? (选择1项)
DECLARE X NUMBER：=0； BEGIN FOR Y IN 1..15 LOOP X：=Y； END LOOP；
END I. 15 J. 16 K. 14
L. 以上都不是
73、如果你进行3个表的联接查询，你最少需要多少个联结条件(选择1项) A) 3 B) 2 C) 1 D) 0