IN(SELECT department_id FROM employee WHERE employee_id = &1); B. SELECT name, department_id, salary FROM employee WHERE department_id
NOT IN(SELECT department_id FROM employee WHERE employee_id = &1) ;
C. SELECT name, department_id, salary FROM employee WHERE department_id =
(SELECT department_id FROM employee WHERE employee_id = &1);
D. SELECT name, department_id, salary FROM employee WHERE (SELECT
department_id FROM employee WHERE employee_id = &1);
66. 在PL/SQL中使用哪几种语句来对变量进行赋值？ (选择3项) A. ：=
B. SELECT INTO C. FETCH INTO D. =
67. 你需要将所属部门名称为“SALES”的所有员工的工资增加10%，你需用哪一句实现? (选择1项)
A. UPDATE emp SET sal = sal * 1.1 WHERE dname LIKE 'SALES' ;
B. UPDATE emp SET sal = sal * 1.1 WHERE deptno =(SELECT deptno FROM emp WHERE dname LIKE 'SALES' );
C. UPDATE emp SET sal = sal * 1.1 WHERE dname =(SELECT deptno FROM emp WHERE dname LIKE 'SALES' );
D. UPDATE emp SET sal = sal * 1.1 WHERE deptno =(SELECT dname FROM emp WHERE dname LIKE 'SALES' )
69.当下列语句执行完后，X的值是多少? (选择1项) DECLARE X NUMBER：=0； BEGIN FOR Y IN 1..15 LOOP X：=Y； END LOOP； END E. 15 F. 16 G. 14
H. 以上都不是
70、下列哪个集合操作符返回两个查询所选择的所有的行。(选择1项) A) Union
B) Union all C) Union only D) Intersect
71、如果你进行3个表的联接查询，你最少需要多少个联结条件(选择1项) A) 3 B) 2 C) 1 D) 0
