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
How to execute a stored procedure in oracle?
How would you go about verifying the network name that the local_listener is currently using?
Describe an oracle table?
Can a formula column referred to columns in higher group ?
How to divide query output into groups in oracle?
State the various uses of dbcc command?
How to Truncate Table in Oracle
What is a cursor in oracle?
What is a read only transaction in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Explain the use of tables option in exp command.
How to set a transaction to be read only in oracle?
How to export data with a field delimiter?
What are the built-in functions used for sending Parameters to forms ?
What is oracle rownum?
