Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14801 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
How to check your oracle database 10g xe installation?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is the difference between a hot backup and a cold backup in oracle?
How to get a create statement for an existing table?
What is Segment Advisor in Oracle?
how to handle exceptions in post production
What is the data pump import utility?
What is a dead lock in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Explain oracle data types with examples?
What is an anonymous block?
Explain the use of show option in imp command.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Are truncate and delete commands same? If so why?
Point the difference between translate and replace?
