Oracle Interview Questions & Answers

Hai all,,,

Here are some important Oracle Interview Questions & Answers.

1.What does a Control file Contain ?
Ans:-The controlfile contains :

1. Name and Location of Datafiles Redo Logfiles.
2. Timestamp of Database Creation.
3. Current log sequence number is recorded when log switches are occur.
4. Checkpoint information is recorded as checkpoints are made.
5. Database identifier is recorded when the database is created.

The controlfile contains
1)Database Name
2)Timestamp
3)Checkpoint information
4)Log Sequence Number
5)archived Log information
6)Undo Information
7)backup Information
8)Redo Information
9)Name and Location of data and log files.
more details...