What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5559 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 ddl statements in oracle?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
How to list all tables in your schema?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
What is the data pump export utility?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
what is exact difference between drop and truncate table.
where we have to use ON clause and where we have to use USING clause in JOINS
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
Define the terms primary key foreign key and also the difference between primary and the unique key
How to recover a dropped index?
Oracle General 
