Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of Control File ?
- 3 Answers
- 6530 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
control file contains crucial information regarding the
database.Without control file u can't open the database.
It maintains integrity of database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / abitha
Control files of a database store the status of the
physical structure of the database. The control file is
absolutely crucial to database operation.
Control file contains:
Database information
Archive log history
Redo threads
database name
Current archive log mode
Database's creation date etc.,
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
various types of hints and their usage
How to convert a date to char in oracle? Give one example.
How to calculate date and time differences in oracle?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
Which Oracle App Is Most Popular One ?
Why use resource manager in Oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
how do u know the total no of rows in a table?
what are the different types of cursors? explain?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
How are the index updates?
Oracle General 
