Explain the difference between ARCHIVELOG mode a

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

18. Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. NOARCHIVELOG mode is basically the absence of ARCHIVELOG mode and has the disadvantage of not being able to recover to any point in time. NOARCHIVELOG mode does have the advantage of not having to write transactions to an archive log and thus increases the performance of the database slightly.

(Continued on next question...)

Other Job Interview Questions

• When looking at the estat events report you see that you are getting busy buffer waits. Is this bad? How can you find what is causing it?
• What is Mirrored on-line Redo Log?
• How can you gather statistics on a table?
• List the Optional Flexible Architecture (OFA) of Oracle database? How can we organize the tablespaces in Oracle database to have maximum performance?
• What are modal windows?
• Explain the use of table functions.
• What is a Tablespace?
• How can I message to passed to the user from reports?
• Physical DB Structure
• What is ROWID?
• More...