What are the basic elements of Base configuration of an
oracle Database ?

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


Please Help Members By Posting Answers For Below Questions

dear sir please provide what question will be asked in bank it officer interview

1930


What is a join in the sql?

767


What is tabular form?

721


What is data modelling techniques?

621


What database does facebook use?

735


what are the differences between an exclusive lock and a shared lock?

775


What are the applications of database management system?

667


Who introduced dbms?

704


Explain data independence?

795


Is excel a database?

728


Explain types of indexing in dbms?

748


Enlist the various relationships of database.

843


What exactly is a database?

651


What is data management process?

744


How to lock records in a table?

731