Jump to content

Oracle Interview Questions & Answers


meena1

Recommended Posts

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.

2.What is the function of SMON?
Ans:- The SMON background process performs all system monitoring functions on the oracle database.

Each time oracle is re-started, SMON performs a warm start and makes sure that the transactions that were left incomplete at the last shut down are recovered.

SMON performs periodic cleanup of temporary segments that are no longer needed.


[url="http://www.coolinterview.com/type.asp?iType=159"]For more details....[/url]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...