Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?

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 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?

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 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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Artie

Artie

Great tinhking! That really breaks the mold!

Magwai

Magwai

When processing a query, Oracle Database often requires temporary workspace for intermediate stages of SQL statement execution. Typical operations that may require atemporary segment include sorting,hashing, and merging bitmaps.