Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / manoj
Hot Backup: Its logical backup of database. It is done while
the database is running. One can backup Entire database or
Users or Tables optinally in this type.
Cold Backup: Its physical backup of the database. It requres
database to be shutdown. Files are physically copied to some
other location as backup.
| Is This Answer Correct ? | 9 Yes | 26 No |
Post New Answer View All Answers
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What would you do with an "in-doubt" distributed transaction?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the different ways you can create databases in sql server? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what are the types of connection load-balancing?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is replication? : sql server DBA
what is logical system in sap basis