Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5390 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to generate query output in html format?
Explain what are the characteristics of data files?
Explain the importance of .pll extension in oracle?
What is a server parameter file in oracle?
How can we find out the duplicate values in an oracle table?
How to recover a dropped table in oracle?
Why do we need oracle client?
What do you mean by merge in oracle?
How to use an explicit cursor without open statements?
Difference between inner join vs where ?
What is a partition in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Explain the blob datatype?
What is oracle used for?
How to create a table index in oracle?
