What are the basic element of Base configuration of an
oracle Database ?
Answers were Sorted based on User's Feedback
Answer / sawant
It consists of
one or more data files.
one or more control files.
two or more redo log files.
The Database contains
multiple users/schemas
one or more rollback segments
one or more tablespaces
Data dictionary tables
User objects (table,indexes,views etc.,)
The server that access the database consists of
SGA (Database buffer, Dictionary Cache Buffers,
Redo log buffers, Shared SQL pool)
SMON (System MONito)
PMON (Process MONitor)
LGWR (LoG Write)
DBWR (Data Base Write)
ARCH (ARCHiver)
CKPT (Check Point)
RECO
Dispatcher
User Process with associated PGS
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
It consists of - one or more data files
- one or more control files
- two or more redo log files
The database contains - Multiple users/schema's
- one or more rollback segments
- one or more tablespaces
- Data dictionary tables
User objects (table, indexes, views etc.)
Is This Answer Correct ? | 0 Yes | 0 No |
What is a Data File ?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
how to produce numbers from 1 to 10 using dual table
What are the different types of record groups in oracle? Explain each of them
What happens if you lost a data file?
can we insert any row to dual table if i got the permission from DBA
What is difference between sid and service name in oracle?
How to find no of saturdays in a month using single sql ?
if i am using dml statement in function. then i am writing select statement what was the output
What are the differences between blob and clob in oracle?
What happens if you set the sga too low in oracle?
Can I create users through internet explorer in oracle 10g?