Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / balakrishna
hot backup mean as we can take backup when the database is
up and running
cold backup we need to shut down the database
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what are the benefits of flashback feature?
What is the difference between clustered and non-clustered index? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : 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 are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what are the performance views in an oracle rac environment?
what is logical system in sap basis
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is grd?
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?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to start SQL Server in minimal configuration mode?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.