Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5265 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 select some rows from a table in oracle?
How to assign values to variables?
what is the difference between substr and instr function in oracle?
Which database is better for os platform dependency?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is the difference between postgresql and oracle?
What is a public synonym?
where do i find oracle interview questions.
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What are the execution control statements?
Explain what does a control file contain?
how many columns can a plsql table have
Oracle General 
