What are the basic elements of Base configuration of an
oracle Database ?
Answer / 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 |
What is the use of FULL option in EXP command ?
What is data abstraction in dbms?
Define ddl interpreter.
Who is end user in database?
What is database in simple language?
What do you mean by super key, primary key, foreign key and candidate key?
What is cold backup ? What are the elements of it ?
What is big data in database?
How big is google's database?
What is the use of GRANT option in EXP command ?
What is database bloat?
How many columns are in a database table?