Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic elements of Base configuration of an
oracle Database ?
- 1 Answers
- 5773 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
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
What are the restrictions applicable while creating views?
What are the Roles and responsibilities of database administrator?
What is structure of dbms?
What are the different types of DBMS architecture?
Explain, why is rdbms better than dbms?
What is e-r model in the dbms?
Enlist the advantages of normalizing database.
Why dbms is used?
What are the functions of database management system?
What are the types of database management system?
What is foreign key in database?
What is variable dbms?
What is building blocks of client/server?
Compare non-clustered and clustered index
Can two oracle blocks have the same address?
