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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the steps you will take to improve performance of a poor performing query?
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 to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you open a cluster administrator? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Which autogrowth database setting is good? : sql server DBA
What is the importance of a recovery model? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Can you redefine a table online?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?