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 is a cursor and what are the steps need to be taken?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to omit columns with default values in insert statement in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is the data type of dual table?
how to clone 9i Database on to 10g Database.
What is a server parameter file in oracle?
Explain an exception and its types?
How to create lov dynamically at runtime & attach to text field?
What are ddl statements in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
Explain the use of tables option in exp command.
How to call a stored function with parameters?
Explain the difference between a procedure and a function?
how to make an oracle object
