Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic elements of Base configuration of an
oracle Database ?
- 1 Answers
- 5847 Views
- I also Faced
- E-Mail Answers
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 stored in a database?
What are views in dbms?
What is the difference between horizontal and vertical partitioning?
Explain a checkpoint and when does it occur?
What is the sql 'in' clause?
What are the five important software components of a database management system?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What is the instance of a relation?
What database does facebook use?
What are the two main functions of queries in databases?
Define denormalization.
What are the four objectives of the selection of a data type?
What is the default '-sort' order for a sql?
Explain why an information gap exists in most organizations.
What is concurrency control?
