Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5281 Views
- I also Faced
- E-Mail Answers
Answer Posted / sawant
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
When do you get a .pll extension in oracle? Explain its importance
Explain the use of rows option in exp command.
Explain an extent?
What is an oracle recycle bin?
How remove data files before opening a database?
What is a relational database management system?
What are the different types of failures that occur in Oracle database?
Can group functions be mixed with non-group selection fields?
What is the difference between sharding and replication?
What is the implicit cursor in oracle?
How to connect the oracle server as sysdba?
What are the attributes that are found in a cursor?
Explain oracle 12c new features for developers?
How many categories of data types in oracle?
Explain the use of record length option in exp command.
