Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / kittu
using hot backup u can backup controlfile @ oracle lever by issuing the "alter database backup controlfile to trace;" or "alter database backup controlfile to '/userdefined_path/control_backup.ctl"
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what do you understand by fine-grained auditing?
How would you extract DDL of a table without using a GUI tool?
What is transparent data encryption? : sql server DBA
What is fill factor? : sql server DBA
what are the differences of where and if in SAS?
What types of replication are supported in sql server? : sql server DBA
how does an oracle clusterware manage crs resources?
Can you redefine a table online?
What is dbcc? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
Explain materialized views and how they are used.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is a correlated sub-query? : sql server DBA
Why would you call update statistics? : sql server DBA
how can you implement fine-grained auditing?