Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14778 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
How to loop through a cursor variable?
What is the difference between translate and replace?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to create a server parameter file?
What is index-organized table in Oracle?
How to use group functions in the select clause using oracle?
Can objects of the same schema reside in different tablespace?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
what is the scenario where you take the database to NoArchivelog mode?
What are the components of logical database structure in oracle database?
What is the use of oracle?
What are the attributes of the cursor?
What is raw datatype in oracle?
How to recover a dropped table in oracle?
Explain the use of tables option in exp command.
