Answer / suman

we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff

Answer / kittu_chintu2005

online backup: 1) inconsistent backup 2) database must be in archive log mode 3) database should be in upon running

offline backup: 1) consistent backup 2)database may be or may not be in archive log mode 3)database should in shut down state

Answer / mogal

as said above every thing is same but one more point. i.e
" in a hot backup it have fractured blocks and where as in
cold backup there is no fractured blocks"

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

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

0 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

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

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---