GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 49 of 74    Print  

What does a Control file Contain ?

A Control file records the physical structure of the database. It contains the following information.

Database Name

Names and locations of a database's files and redolog files.

Time stamp of database creation.




  
Total Answers and Comments: 4 Last Update: September 20, 2007   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Aruna
 

Controlfile contains

  • name and id of database
  • time stamp of database creation
  • names and location of datafiles
  • names of tablespaces
  • current SCN number
  • current LSN number
  • Checkoint information
  • Backup


Above answer was rated as good by the following members:
rnraomaddula
January 29, 2006 10:10:50   #1  
DIPTENDU HUI        

RE: What does a Control file Contain ?

Control File contains

1) Name and location of all Datafiles.
2)Name and location of all redolog files.
3)Current log sequence Number.


 
Is this answer useful? Yes | No
March 03, 2006 08:25:23   #2  
Aruna        

RE: What does a Control file Contain ?

Controlfile contains

  • name and id of database
  • time stamp of database creation
  • names and location of datafiles
  • names of tablespaces
  • current SCN number
  • current LSN number
  • Checkoint information
  • Backup

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
March 07, 2006 06:23:12   #3  
nagabhushan reddy Member Since: December 2005   Contribution: 4    

RE: What does a Control file Contain ?

control file is a binary file

which having information 1.database name

2.database creation

3.checkpoint information

4.no of datafiles

5.redolog files


 
Is this answer useful? Yes | No
September 20, 2007 00:35:24   #4  
Mohammed Abdul Afroze        

RE: What does a Control file Contain ?

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.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape