[多选]
Examine the data in the EMPLOYEES table:
LAST_NAME DEPARTMENT_ID SALARY
Getz 10 3000
Davis 20 1500
Bill 20 2200
Davis 30 5000
...
Which three subqueries work? （）

A . SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);
B . SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);
C . SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);
D . SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);
E . SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);
F . SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY))

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）； You need statistics to be collected more quickly. What can you do to achieve this？（） Set DYNAMIC_SAMPLING to level 4。 Set the STATISTICS_LEVEL parameter to BASIC。 Set the INCREMENTAL value to TRUE for the partition table。 Increase the value of STALE_PERCENT for the partition table。保护瓶阀用的帽罩式安全附件的统称叫（）。瓶帽。护罩。瓶耳。在封建社会后期，复古成为一种强大的文化思潮，在明代诗坛上前后出现过两次的复古思想，史称“前后七子”的复古诗文运动，其中前七子的领袖是（）、（）。后七子的领袖是（）、（）。简述1942年前后解放区文学的变化。地基基础工程中常见的质量通病有（）。 A.地基不均匀沉降。 B.预应力砼管桩桩身断裂。 C.挖方边坡塌方。 D.基坑（槽）回填土沉陷。

Examine the data in the EMPLOYEES table:
LAST_NAME DEPARTMENT_ID SALARY
Getz 10 3000
Davis 20 1500
Bill 20 2200
Davis 30 5000
...
Which three subqueries work? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

[多选] Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）

相关题目:

[多选]
Examine the data in the EMPLOYEES table:
LAST_NAME DEPARTMENT_ID SALARY
Getz 10 3000
Davis 20 1500
Bill 20 2200
Davis 30 5000
...
Which three subqueries work? （）