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"

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

how can you record information about current session?

0 Answers   Oracle,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

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

0 Answers  

---

why do we give pctfree and pctused in create table statement?

1 Answers   CTS,

---

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

what is the use of home directory???

1 Answers   HP,

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---