What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 13806 Views
- I also Faced
- E-Mail Answers
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
What is an oracle user role?
How will you differentiate between varchar & varchar2?
what is the scripts in data base?
What are the different oracle database objects?
query optmization techniques and quwry analyser+projects+ppts
How to update values in a table in oracle?
What is a database schema in oracle?
Explain about functional dependency and its relation with table design?
What exactly do quotation marks around the table name do?
Can a formula column referred to columns in higher group ?
How to add a new column to an existing table in oracle?
Explain user account with reference to oracle.
What is the usage of control file in oracle?
State some uses of redo log files?
How do I manually uninstall oracle client?
