Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / sandeep
Cold Backup - In this case, they take the database down
then they have backup. this is called cold backup.
Hot Backup - In this case, they take running database
backup (like SQL Server) this is called hot backup.
| Is This Answer Correct ? | 29 Yes | 1 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how can you process messages in order asynchronously?
what is logical system in sap basis
What is the difference between dropping a database and taking a database offline? : sql server DBA
What authentication modes does sql server support? : sql server DBA
Where would you look for errors from the database engine?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what are the benefits of flashback feature?
What are the different sql server versions you have worked on? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the difference between clustered and non-clustered index? : sql server DBA
What is the importance of a recovery model? : sql server DBA
what is asm?