What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 13737 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 the usage of save points in oracle database?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is the difference between 10g OEM and 11g OEM?
What is tns service name?
What happens in oracle commit?
How to work with data objects interactively?
Is it possible to insert comments into sql statements return in the data model editor ?
What is blob datatype?
What are the differences between primary key and unique key?
How to change program global area (pga) in oracle?
What is a dead lock in oracle?
What is define in oracle?
Explain the use of compress option in exp command.
How to write text literals in oracle?
What is procedure overloading in oracle?
