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 export several tables together?
Can select statements be used on views in oracle?
Explain mutating triggers.
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What is oracle and what are its different editions?
What is oracle database 10g express edition?
How to get last row id?
How to delete all rows a table in oracle?
How to rename a column in an existing table?
What is java oracle used for?
What do you understand by a database object? Can you list a few of them?
Explain the use of grant option in imp command.
How remove data files before opening a database?
Is the After report trigger fired if the report execution fails ?
What is rich query?