053-155

Observe the structure of the table employees: The table contains 8475 records.

One of the employees wants to know the names of all employees of the company. For this, he fires the following query:
SELECT * FROM EMPLOYEES ORDER BY emp_fname;
Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation. Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?
A. Rollback segment
B. Temporary segment
C. Data segment
D. Index segment

当进行查询时，Oracle 数据库经常需要临时工作空间在中间存储 SQL 语句执行。一般是在临时段中进行排序，哈希和位图合并。当创建索引时，Oracle 也将索引段放置到临时段中， 当索引完成后将其转为固定段。
当内存足够是，oracle 不会为操作创建临时段。但是当内存不足的时候，oracle 会自动的在磁盘上分配临时段。
由于临时段的分配和释放比较频繁，所以最好为临时段创建一个单独的表空间。将临时表空间放置到于system 和其他表空间不同的磁盘上，避免磁盘 I/O 的争用。
根据题意是内存不足，需要使用磁盘空间来存放结果，此时分配的应该是临时段。 A.C.D 错误

转载于:https://www.cnblogs.com/Babylon/p/7844379.html