CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS ORACLE DETAILS
Question :
Which file is used to record all changes made to the database and is used only
when performing an instance recovery?

Category Oracle Interview Questions
Rating (0.0) By 0 users
Added on 7/7/2005
Views 786
Rate it!
Answers:

Redo logs are used to record all changes to the database. The redo log buffer in the SGA is written to the redo log file periodically by the LGWR process, which is used to roll forward, or to update, the data files during an instance recovery.






If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
What is the biggest advantage of having the control files on different disks?
View Answer
Which data dictionary view shows that the database is in ARCHIVELOG mode?
View Answer
The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?
View Answer
Which data dictionary view provides the names of the control files?
View Answer
When you create a control file, the database has to be:
View Answer
What piece of information is not available in the control file?
View Answer
What is the best method to rename a control file?
View Answer
Which optional component in the database creation process sets up functions and procedures to store, access, and analyze data needed for Geographical Information Systems (GIS)?
View Answer
Which clauses in the CREATE DATABASE command specify limits for the database?
View Answer
Which clauses in the CREATE DATABASE command specify limits for the database?
View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL Oracle Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/4680/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

1.78