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
Is sql a rdbms?
What is database management system(dbms)?
What are the five steps of data modeling?
what is the difference between two and three-tier architectures?
What is a clause in terms of sql?
Describe a subquery.
Explain the term entity type in dbms?
Explain the terms database and dbms?
What are different type of normalization?
How is foreign key commands related to primary key?
Define phantom deadlock.
What is database join?
Define dml compiler.
Explain the syntax of named procedure?
What is ordbms with example?