What is cold backup, hot backup, warm backup rec

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

(Continued from previous question...)

4. What is cold backup, hot backup, warm backup recovery?

Cold backup (All these files must be backed up at the same time, before the databaseis restarted). Hot backup (official name is ‘online backup’) is a backup taken of each tablespace while the database is running and is being accessed by the users.

(Continued on next question...)

Other Job Interview Questions

• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What is a data source?
• Is the JDBC-ODBC Bridge multi-threaded?
• What is a data source?
• What is a data source?
• When we will Denormalize data?
• What is Metadata and why should I use it?
• What are different types of Transaction Isolation Levels?
• What is the normal procedure followed by a java client to access the db.?
• What is cold backup, hot backup, warm backup recovery?
• More...