Multiple choice technology

What are the different types of segments in Oracle?

  1. 1- Data segment, 2 - Disk segment, 3- Table segment

  2. 1-Table segment,2-Temporary segment, 3 - View Segment

  3. 1- Data segment,2- Index segment,3- Temporary segment,4- Rollback segment

  4. 1- Data segment,2- Index segment,3- View segment,4- disk segment
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Oracle uses different types of segments to store data efficiently. Data segments store table data, index segments store index structures, temporary segments hold intermediate results during sort operations, and rollback segments store before-images for transaction rollback and recovery. Option C correctly lists all four fundamental segment types used in Oracle database storage management.

Keep practicing — related questions