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
What is file manager?
What are different cursor types in dbms?
Can you explain insert, update and delete query?
What is an entity-relationship model?
Explain what are called fat clients and fat servers?
What is a file in a database?
What is compound key?
What is data model and types?
What are the importance of database in banking?
Enlist some commands of dml?
What is primary key in dbms?
What is dbms and its functions?
Explain the role of metadata for the three-layer architecture.
Which database is best for large data?
What is system r?