Answer Posted / shabbeer.ahmad

A hot backup is basically taking a backup of the database
while it is still up and running and it must be in archive
log mode. A cold backup is taking a backup of the database
while it is shut down and does not require being in archive
log mode. The benefit of taking a hot backup is that the
database is still available for use while the backup is
occurring and you can recover the database to any point in
time. The benefit of taking a cold backup is that it is
typically easier to administer the backup and recovery
process. In addition, since you are taking cold backups the
database does not require being in archive log mode and thus
there will be a slight performance gain as the database is
not cutting archive logs to disk.

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2464

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1009

---

How can you control the amount of free space in your index pages? : sql server DBA

1314

---

What are the operating modes in which database mirroring runs? : sql server DBA

1188

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2360

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1210

---

how can a session indicate its interest in receiving alerts?

1046

---

what is grd?

1101

---

What is the importance of a recovery model? : sql server DBA

1031

---

how does an oracle clusterware manage crs resources?

1092

---

What is transparent data encryption? : sql server DBA

1199

---

What is replication? : sql server DBA

1179

---

Why does Oracle not permit the use of PCTUSED with indexes?

2944

---

What are statistics, under what circumstances they go out of date, how do you update them?

2253

---

Can you redefine a table online?

1117

---