Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5404 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
Differentiate between function and procedure in oracle.
Explain temporal data types in oracle
How to declare a local variable?
How to check the oracle tns settings?
What is instant client oracle?
Is oracle a programming language?
what is a Nested Loop join?
what are the default admin accounts in Oracle 10g ?
What is proxy method?
What is the difference between substr and instr?
What is a snapshot log?
Can a formula column be obtained through a select statement ?
How to retrieve the count of updated rows?
What is a data lock in oracle?
Give the advantages and disadvantages of clusters.
