Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nishi
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
Controlfile contains the information about the database like names and locations of datafiles, name of the database, database creation timestamp and apart from this the SCN are also reported into control during the database operation. Especially during the database startup the controlfile is used to gather the information about the database and while opening the database the information in the controlfile is validated to check for the consistency of the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens to indexes if you drop a table?
How to create a table index?
Explain the use of indexes option in imp command.
What is oracle rownum?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is instant client oracle?
What are the benefits of ordbms?
What is an oracle and why it is used?
Point out the difference between user tables and data dictionary?
What is recycle bin in Oracle?
How to create a new oracle data file?
How many types of auditing in Oracle?
What is a nvl function?
How to loop through data rows in the implicit cursor?
Can the query output be sorted by multiple columns in oracle?
