What do you understand by a control file?
Answer / Gaurav Maheshwari
A Control File is a critical file in an Oracle database used for recovery purposes. It stores important metadata about the database, including database name, database files locations, online redo log sequence numbers, and more. The Control File is essential during database startup and recovery.
| Is This Answer Correct ? | 0 Yes | 0 No |
If you have an example table, what is the best way to get sizing data for the production table implementation?
What is difference between co-related sub query and nested sub query?
What is the difference between rman and a traditional hotbackup?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What does dba stand for database?
What os user should be used for the first part of an oracle installation (on unix)?
How can you find your id on a system?
What is a dba programmer?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What degree do database administrators need?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?