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
Answer: B
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT1072
题意是：由于执行的查询不能完全装入内存，它需要磁盘空间来完成操作。
临时段是用来进行排序操作的临时磁盘空间。
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
Answer: B
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT1072
题意是：由于执行的查询不能完全装入内存，它需要磁盘空间来完成操作。
临时段是用来进行排序操作的临时磁盘空间。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2119566/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q96
下一篇：
1Z0-053 V13.02 Q250
请登录后发表评论
登录
全部评论
