Segment types - Oracle Architecture - Data Segment

Q.  Which of the following are types of segments?
- Published on 13 Aug 15

a. Permanent segment
b. Object segment
c. Data Segment
d. All of the above

ANSWER: Data Segment
 

    Discussion

  • Nirja Shah   -Posted on 26 Aug 15
    -A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace.
    -For example, for each table, Oracle Database allocates one or more extents to form that table's data segment, and for each index, Oracle Database allocates one or more extents to form its index segment.

    -Data Segment - A single data segment in an Oracle Database database holds all of the data for one of the following:
    1. A table that is not partitioned or clustered
    2. A partition of a partitioned table
    3. A cluster of tables

    -Oracle Database creates this data segment when you create the table or cluster with the CREATE statement.

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