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
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Give the various exception types.
How to get a list of all user accounts in the database?
How view is different from a table?
How does one get the view definition of fixed views/tables?
How to unlock the sample user account in oracle?
What is a system tablespace?
Differentiate between pre-select and pre-query?
What are dml statements in oracle?
When do you get a .pll extension in oracle? Explain its importance
What is a initialization parameter file in oracle?
State the difference between a primary key and foreign key?
How to rename a column in an existing table?
How to sort output in descending order in oracle?
How to revoke create session privilege from a user in oracle?
