Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5291 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 sort the query output in oracle?
What are the advantages of Views ?
What privilege is needed for a user to create views in oracle?
Explain about integrity constraint?
"primary key=unique+null" is equal,reson?not,reason?
Can u make a synonym for deptno=10 only from emp table.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Give the advantages and disadvantages of clusters.
What is meant by redo log buffer ?
What is a table index in oracle?
how to we delete a row using varray
How can I combine multiple rows into a comma-delimited list in oracle?
Oracle General 
