what is difference between cold backup and hot backup

Question

Accepted Answer

Cold backup is taken when the database is offline while hot backup is taken when the database is online.

Cold backup is taken when the database is shut down and all files are copied to a backup location.
Hot backup is taken while the database is still running and all files are copied to a backup location.
Cold backup is slower and requires downtime while hot backup is faster and does not require downtime.
Cold backup is more reliable as there is no chance of data being changed during backup while hot backup may have some data inconsistencies.
Cold backup is suitable for small databases while hot backup is suitable for large databases with high availability requirements.

Top Wistron Oracle Database Administrator interview questions & answers