Concepts and Architecture Question:

Download Job Interview Questions and Answers PDF

What is a Data Segment in Oracle?

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

Answer:

The level of logical database storage above an extent is called a segment. A segment is a set of extents, each of which has been allocated for a specific data structure and all of which are stored in the same tablespace. For example, each tables data is stored in its own data segment, while each index data is stored in its own index segment. If the table or index is partitioned, each partition is stored in its own segment.

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what is the command to find the database that already present before connecting?Can we add a column to view in Oracle?