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
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Why do we use bulk collect in oracle?
Explain how you would restore a database using RMAN to Point in Time?
What privilege is needed for a user to create views in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What is a proxy object?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is the disadvantage of User defind function?
What is the use of aggregate functions in oracle?
What to do if the binary spfile is wrong for the default instance?
What is blob data type in oracle?
How to use windows user to connect to the server?
Can group functions be used in the order by clause in oracle?
How to turn on or off recycle bin for the session?
1) Does oracle have any table which contain all the exceptions and it's code internally?