What are the components of Logical database structure of
ORACLE database?
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 |
Name the various constraints used in oracle?
How different is ms access and oracle?
what is null value?
What do you mean by group by clause?
What is a trigger and what are its types?
Difference between open_form and call_form in oracle.
What are the different types of trigger and explain its various uses and functions?
How to end the current transaction in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Can you assign multiple query result rows to a variable?
how can we store any pdf file in oracle
How to filter out duplications in the returning rows using oracle?