Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
- 7 Answers
- 19294 Views
- TCS, I also Faced
- E-Mail Answers
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
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
How would you go about verifying the network name that the local_listener is currently using?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is the diffrence between core dba and apps dba?
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
when does an alert gets signaled?
Why would you use sql agent? : sql server DBA
What is dbcc? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What is replication? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
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 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?
