What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 4945 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 start your 10g xe server from command line?
What are the uses of synonyms?
What is a user role in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to unlock the sample user account in oracle?
Explain an exception and its types?
what is null value?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
What is a parameter file in oracle?
Can group functions be mixed with non-group selection fields?
What privilege is needed for a user to create tables in oracle?
What is memory advisor in Oracle?
Oracle General 
