What are the components of Logical database structure of
ORACLE database?
Answer Posted / jidnesh
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.
A group of data blocks forms an extent.
An extents groups tends to segments, and lastly a group of
segment forms a tablespace.
Is This Answer Correct ? | 26 Yes | 4 No |
Post New Answer View All Answers
In what script is snap$ created? In what script is the scott/tiger schema created?
What is an index associated with a constraint?
How to run queries on external tables?
Is there an oracle sql query that aggregates multiple rows into one row?
What is logical backup in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain about integrity constraint?
What are the arithmetic operations?
What is backup in Oracle?
definition of cluster and non-clustered index?
What is meant by a deadlock situation?
How to write a query with a left outer join in oracle?
How remove data files before opening a database?
How to export your own schema?
Explain table?