Oracle题库 - 71道

63. 你认为下面句子将完成什么任务？ (选择1项) GRANT UPDATE ON EMPLOYEES TO AZURE; E. 一个新的对像被创建。

F. 一个新的对像权限被赋予。 G. 一个新的系统权限被赋予。 H. 一个对像的同义词被创建。

64. 哪条 SELECT 语句可得到单价大于15.00的所有产品的平均单价? (选择1项) C. SELECT SUM(*) FROM products WHERE price > 15.00; B. SELECT AVG(*) FROM products WHERE price > 15.00;

D. SELECT AVG(price) FROM products WHERE price > 15.00;

D. SELECT AVG(DISTINCT price) FROM products GROUP BY price >1 5.00;

65. 查找和用户指定雇员Id为&1的所属部门相同的所有雇员的姓名、部门、薪金，以下那条语句可以实现？(选择1项) B.

SELECT

name,

department_id,

salary

FROM

employee

WHERE

department_id 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项) E. ：=

F. SELECT INTO G. FETCH INTO H. =

67. 你需要将所属部门名称为“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' )

68. 当fetch执行失败时，哪种游标的属性值为TRUE：(选择1项) E. %ISOPEN. F. %FOUND.

G. %NOTFOUND. H. %ROWCOUNT.

69.当下列语句执行完后，X的值是多少? (选择1项) I. J. K. L.

DECLARE X NUMBER：=0； BEGIN

FOR Y IN 1..15 LOOP X：=Y； END LOOP；

END 15 16 14

以上都不是

70、下列哪个集合操作符返回两个查询所选择的所有的行。(选择1项) A) Union

B) Union all C) Union only D) Intersect

71、如果你进行3个表的联接查询，你最少需要多少个联结条件(选择1项) A) 3 B) 2 C) 1 D) 0