Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5416 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 |
What are various joins used while writing SUBQUERIES?
Give the constructs of a package, function or a procedure.
Explain the features of oracle?
What is an Index ?
What is oracle open database communication (odbc)?
What is define in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is Rollback Segment ?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are the ansi data types supported in oracle?
What is self-referential integrity constraint ?
How to use values from other tables in update statements using oracle?
Oracle General 
