Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14772 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rameshkumar.k
The logical DB contains shared pool(library cache,data dictionary cache),data buffer cache,redolog buffer,java buffer and large pool.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nishi
There are tablespaces and database's schema objects.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is a Database instance ? Explain?
State the difference between a primary key and foreign key?
why pl sql doesn't support retrieving multiple records
What are the most common interview questions on ETL Testing for experience?
What is sequence?
What is Index and different types of Indexes?
how many columns can a plsql table have
After using set unused can we enable the column again to use? Please give me some answers....
What is Database Buffers ?
what is main def between plsql/table and array?
Why does oracle 9i treat an empty string as null?
What is the difference between truncate & delete command?
Oracle General 
