Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / vaishnav
when the database is closed then this backup is called cold
backup. while, when the database is running/opened then
this backup is called hot backup.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
How would you go about verifying the network name that the local_listener is currently using?
What are the commands used in dcl? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can a session indicate its interest in receiving alerts?
What are the steps you will take to improve performance of a poor performing query?
what are the benefits of flashback feature?
how can you create a user-defined lock?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is fill factor? : sql server DBA
what do you understand by fine-grained auditing?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Where would you look for errors from the database engine?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the recovery models for a database? : sql server DBA