Temporary segment is destroyed when SQL statement is finished - Oracle Architecture

Q.  Which of the following segment is destroyed when the SQL statement is finished?
- Published on 03 Aug 15

a. Temp segment
b. Object segment
c. Data Segment
d. Temporary segment

ANSWER: Temporary segment
 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    -Oracle allocates space for segments in units of one extent.

    -Temporary segment - Created when a SQL statement needs a temporary work area; these segments are destroyed when the SQL statement is finished. These segments are used during various database operations, such as sorts.

    -Data segment - It stores user data within the database.

    -Temp segment - There is a temporary tablespace called as temp which is used internally by the database for operations like distinct join etc.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)