Oracle Database Architecture Question:

Download Job Interview Questions and Answers PDF

What is the use of Oracle Control File?

Database Architecture Interview Question
Database Architecture Interview Question

Answer:

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.

Control files is a binary file. Before database is opened it determines whether database is in valid state or not. If yes then database is opened.

Download Database Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
Can objects of the same Schema reside in different tablespaces?Can a View based on another View in Oracle?