更多IT认证资源 美河学习在线 www.eimhe.com
1 / 90
1z0-071
1. Examine the description of the EMPLOYEES table:
Name
Null?
Type
EMP_ID
NOT NULL
NUMBER
EMP_NAME
VARCHAR2(40)
DEPT_ID
NUMBER(2)
SALARY
NUMBER(8,2)
JOIN_DATE
DATE
Which query is valid?
A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
C. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
Answer: A
解析：
纳入分组的字段必须全部出现在 GROUP BY 子句中；
在进行分组聚合操作时，不能对聚合函数进行嵌套使用。
2. Which three are true about the CREATE TABLE command? (with the version before 11g)
A. It can include the CREATE ... INDEX statement for creating an index to enforce the primary key
constraint.
B. The owner of the table should have space quotas available on the tablespace where the table is
defined.
C. It implicitly executes a commit.
D. It implicitly rolls back any pending transactions.
E. A user must have the CREATE ANY TABLE privilege to create tables.
F. The owner of the table must have the UNLIMITED TABLESPACE system privilege.
Answer: ABC
解析：
创建表的时候可以同时创建索引；
创建表（未开延迟段创建）时，需要用户对存储表的表空间有空间使用配额；
创建表 CREATE TABLE 中 DDL 语句，创建成功后自动执行 COMMIT，且对会话之前未提
交的事务一起提交；
用户需要有 create table 的权限即可创建表。
3. Which is the default column or columns for sorting output from compound queries using SET operators
such as INTERSECT in a SQL statement?
A. The first column in the last SELECT of the compound query
B. The first NUMBER column in the first SELECT of the compound query
C. The first VARCHAR2 column in the first SELECT of the compound query
D. The first column in the first SELECT of the compound query
E. The first NUMBER or VARCHAR2 column in the last SELECT of the compound query
Answer: DE
剩余89页未读，继续阅读
资源评论
qq_335109122024-09-18内容与描述一致，超赞的资源，值得借鉴的内容很多，支持！
