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
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 get actual data change values from previous transactions in oracle?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How do you open a cluster administrator? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What the different types of replication and why are they used? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you communicate with operating system files from oracle?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Query processing is slow(eg select query)how will u solve that
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is replication? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit