Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14977 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 |
Explain integrity constraints?
What is the use of file param in imp command?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the difference between a user and a schema in oracle?
What is a parameter file in oracle?
What is a data segment ?
How to download oracle database 10g xe?
Explain the use of record length option in exp command.
Explain overloading. Can functions be overloaded?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
How to bring a tablespace online?
Oracle General 
