Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
What is a Temporary Segment in Oracle?
Answer:
temporary segments are basically used for sort operations in oracle,,when the user tries to execute the query through order by clause. so system needs an space for an sort operation, and system will use temporary segments for this query.
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is Row Chaining in Oracle? | What is an Index in Oracle? |