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

Is sql a rdbms?

620


What is database management system(dbms)?

734


What are the five steps of data modeling?

666


what is the difference between two and three-tier architectures?

674


What is a clause in terms of sql?

862


Describe a subquery.

753


Explain the term entity type in dbms?

752


Explain the terms database and dbms?

713


What are different type of normalization?

726


How is foreign key commands related to primary key?

609


Define phantom deadlock.

714


What is database join?

668


Define dml compiler.

808


Explain the syntax of named procedure?

762


What is ordbms with example?

679