Oracle 11G OCP 1Z0-053 155

（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

答案：（B）

解析：

内存排序空间不足，用的是临时表空间下的临时段来辅助排序

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1258539/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1258539/