INTERVIEW QUESTIONS ORACLE CONCEPTS AND ARCHITECTURE DETAILS

Question: What is the use of Control File ?

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.

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. Source: CoolInterview.com

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. Source: CoolInterview.com

control file is a binary file which holds the current status of the database.so we need to maintain at least 2 different locations. Source: CoolInterview.com

the control file is a binary file maintained by oracle server that defines the current stage of the physical database.it is read in mount stage and each file is associated with a single database.it should be multiplexed,at least one control file is required but it can be multiplexed up to eight times.if for some reason the control file is not accessible,the database does not function properly
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question