OCP-1Z0-053-200题-125题-155

QUESTION 125

Observe the structure of the table employees:

DESC employees

Name Null? Type

------------------ --------------- ----------------------

emp_no NOT NULL VARCHAR(5) PRIMARY KEY

emp_fname NOT NULL VARCHAR (15)

emp_lname NOT NULL VARCHAR (15)

emp_dob NOT NULL DATE

emp_dtofjoin NOT NULL DATE

emp_salary NUMBER(5,2)

The table contains 8475 records.

One of the employees wants to know the names of allemployees of the company. For this, he fires the

following query:

SELECT * FROM EMPLOYEES ORDER BY emp_fname;

Since the operation performed on executing the querycannot 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

同155题：http://blog.csdn.net/rlhua/article/details/13503817

Explanation/Reference:

Section: SQL, PL/SQL, Packages, Functions, Jobs & Views