What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 4842 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nishi
It consists of - one or more data files
- one or more control files
- two or more redo log files
The database contains - Multiple users/schema's
- one or more rollback segments
- one or more tablespaces
- Data dictionary tables
User objects (table, indexes, views etc.)
| Is This Answer Correct ? | 0 Yes | 0 No |
How to add a new column to an existing table with a default value?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How to use in conditions in oracle?
Explain an index?
How to view all columns in an existing table?
Explain enable novalidate constraint.
What is key preserved table?
What is set operator oracle?
what is the difference between simple view and complex view?
Is oracle a programming language?
What is STATSPACK tool?
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
Oracle General 
