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
What is meant by raw datatype?
How to invoke the data pump import utility?
When do I need to use a semicolon vs a slash in oracle sql?
What is data block in Oracle?
What is the usage of merge statement?
What is transport network substrate (tns) in oracle?
What is the difference between substr & instr functions?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is a database table in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What are the built-in functions used for sending Parameters to forms ?
what is the difference between functional dependecy and multilevel dependency?
What is analyze command used for?
What is Reduced List of Values?
What is oracle rownum?