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 are the set operators union, union all, minus & intersect meant to do?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the various oracle database objects?
How to put more than 1000 values into an oracle in clause?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain the types of exception?
Explain implicit cursor.
How to create a new table in your schema?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What exactly do quotation marks around the table name do?
What is a sub query? What are its various types?
What is a system tablespace and when it is created?
What is oracle host variable?
Explain alias?
