What are the advantages of operating a database

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

(Continued from previous question...)

3. What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?

Complete database recovery from disk failure is possible only in ARCHIVELOG mode. Online database backup is possible only in ARCHIVELOG mode.

(Continued on next question...)

Other Job Interview Questions

• Can objects of the same Schema reside in different tablespaces?
• What is a Static Record Group?
• What are some indications that you need to increase the SHARED_POOL_SIZE parameter?
• What is Hash Cluster?
• When should you increase copy latches? What parameters control copy latches?
• Physical DB Structure
• What is a trace file and how is it created?
• What is Database Link?
• How to define Data Block size?
• What are the default parameter that appear at run time in the parameter screen?
• More...