INTERVIEW QUESTIONS ORACLE ORACLE ARCHITECTURE DETAILS

Question: Explain the types of data files used by the oracle RDBMS.

Answer: Online redo log files
A control file contains information such as location of redo log files, backup data and redo log information.

The control file is updated to reflect the structure changes every time a datafile or a redo log file is added or dropped from the database. These records are necessary to identify datafiles and redo log files during startup and recovery.

Archive log files
Archived log files are redo logs that Oracle fills with redo entries that are rendered inactive and copied to one or more log archives.

Running the database in ARCHIVELOG mode has the following benefits:

* Complete recovery of database from instance and media failure.
* Performing online backups.
* Transmitting and applying archived redo logs to the standby database.
* Multiplexed archive logs to avoid single point of failure on the archive logs.
* More recovery options (tablespace-point-in-time recovery)

Initialization files
Initialization parameter file is a text file in ASCII which contains information needed to initialize a database and instance.

Control files
Control Files contain:

* The physical structure of a database
* Database name,
* Names and locations of associated databases and online redo log files, Timestamp of database creation,
* Current log sequence number
* Checkpoint information.

Online redo log files
A control file contains information such as location of redo log files, backup data and redo log information.

The control file is updated to reflect the structure changes every time a datafile or a redo log file is added or dropped from the database. These records are necessary to identify datafiles and redo log files during startup and recovery.

Archive log files
Archived log files are redo logs that Oracle fills with redo entries that are rendered inactive and copied to one or more log archives.

Running the database in ARCHIVELOG mode has the following benefits:

* Complete recovery of database from instance and media failure.
* Performing online backups.
* Transmitting and applying archived redo logs to the standby database.
* Multiplexed archive logs to avoid single point of failure on the archive logs.
* More recovery options (tablespace-point-in-time recovery)

Initialization files
Initialization parameter file is a text file in ASCII which contains information needed to initialize a database and instance.

Control files
Control Files contain:

* The physical structure of a database
* Database name,
* Names and locations of associated databases and online redo log files, Timestamp of database creation,
* Current log sequence number
* Checkpoint information. 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