What does a Control file Contain ?

Answer Posted / orawhiz

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.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of online redo log files in oracle.

810


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1848


Explain about functional dependency and its relation with table design?

805


Define oracle database

821


Give the various exception types.

771


query optmization techniques and quwry analyser+projects+ppts

2184


How to use windows user to connect to the server?

769


What happens to the current transaction if the session is killed?

777


What is a table in oracle?

753


Explain drop constraint oracle?

818


How can I create database in oracle?

790


What is connection pooling in oracle?

761


What are a collation and state the different types of collation sensitivity?

818


How to connect to a local oracle 10g xe server?

766


How can we find out the duplicate values in an oracle table?

849