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
Why packages are used in oracle?
What happens in oracle commit?
What are the extensions used by oracle reports?
Hi Can any one tell me what are the API's used in requisition import.
What is Redo Log Buffer in Oracle?
In which language oracle has been developed?
Can we protect our pl/sql source code?
What is oracle sid?
Point the difference between translate and replace?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Explain how you would restore a database using RMAN to Point in Time?
What do you mean by merge in oracle?
What is the quickest way to export a table to a flat file?
what is the dual table in oracle?
How to call a sub procedure?