发布时间 : 星期一 文章Oracle题库 - 71道更新完毕开始阅读25940566783e0912a2162aba
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