Identify, which of the following are types of segments?

Options
- Permanent segment
- Object segment
- Data Segment
- All of the above


CORRECT ANSWER : Data Segment

Discussion Board
Data Segment

A segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. A single data segment in an Oracle database holds all of the data for one of the following:
A table that is not partitioned or clustered.
A partition of a partitioned table.
A cluster of tables.
Oracle creates this data segment when you create the table or cluster with the CREATE statement.

Prajakta Pandit 02-16-2017 06:49 AM

Write your comments


Enter the code shown above:

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


Advertisement