Explain the difference between a hot backup and

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

(Continued from previous question...)

124. Explain the difference between a hot backup and a cold backup and the benefits associated with each.

A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode. The benefit of taking a hot backup is that the database is still available for use while the backup is occurring and you can recover the database to any point in time. The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process. In addition, since you are taking cold backups the database does not require being in archive log mode and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

(Continued on next question...)

Other Job Interview Questions

• What is a deadlock and Explain?
• What are the built-ins used for finding object ID functions?
• What are the types of SQL statement?
• What are the values that can be specified for OPTIMIZER MODE Parameter?
• What is an object group?
• You have just compiled a PL/SQL package but got errors, how would you view the errors?
• Use the add_group_column function to add a column to record group that was created at a design time?
• What is the diff. when Flex mode is mode on and when it is off?
• Does a Before form trigger fire when the parameter form is suppressed?
• How do you display console on a window?
• More...