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
How to manage transaction isolation level?
What is MTTR advisor in Oracle?
How to start a new transaction in oracle?
How to use "for" statements in oracle?
Differentiate between function and procedure in oracle.
Explain table?
What are named parameters?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to grant create session privilege to a user in oracle?
What is primefaces used for?
What is parameterized cursor in oracle?
How to convert characters to numbers in oracle?
What is the difference between online and offline backups?
What are the different types of database objects?
How to login to the server without an instance?