What is a Temporary Segment ? - Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use. - Concepts and Architecture Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

CONCEPTS AND ARCHITECTURE

DETAILS

Question: What is a Temporary Segment ?

Answer: Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.

Category	Concepts and Architecture Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 7875 users
Added on	10/27/2009
Views	72086
Rate it!

Question: What is a Temporary Segment ?

Answer:

Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is a Data File ?	View Answer
	What are the Characteristics of Data Files ?	View Answer
	What is a Redo Log ?	View Answer
	What is the function of Redo Log ?	View Answer
	What is the use of Redo Log Information ?	View Answer
	What does a Control file Contain ?	View Answer
	What is the use of Control File ?	View Answer
	What is a Data Dictionary ?	View Answer
	What is an Integrity Constrains ?	View Answer
	Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?	View Answer
	Describe the different type of Integrity Constraints supported by ORACLE ?	View Answer
	What is difference between UNIQUE constraint and PRIMARY KEY constraint ?	View Answer
	Describe Referential Integrity ?	View Answer
	What are the Referential actions supported by FOREIGN KEY integrity constraint ?	View Answer
	What is self-referential integrity constraint ?	View Answer
	What are the Limitations of a CHECK Constraint ?	View Answer
	What is the maximum number of CHECK constraints that can be defined on a column ?	View Answer
	What are the components of Physical database structure of Oracle Database?	View Answer
	What are the components of Logical database structure of ORACLE database?	View Answer
	What is a Tablespace?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Concepts and Architecture Interview Questions & Answers - Exam Mode / Learning Mode