What are the components of logical database structure of Oracle database?

What are the components of logical database structure of Oracle database?

The Logical Database Structure of an Oracle include : 
> The schema objects,
> Data blocks,
> Extents,
> Segments and
> Tablespaces.

> schema objects : means table, index, synonyms, sequences etc.

> Data blocks : are the smallest part of the oracle database defined by DB_BLOCK_SIZE parameter.

> Extent : A group of data blocks forms an extent.

> Segments : An extents groups tends to segments,

> Table space : lastly a group of segment forms a tablespace.

By:UMANG
Date:2009-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher