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"

Explain an ORA-01555

2 Answers  

---

what is the use of ocr?

1 Answers   Oracle,

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1 Answers  

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1 Answers  

---

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

2 Answers   IBM,

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

What the different components in replication and what is their use? : sql server DBA

1 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

Which autogrowth database setting is good? : sql server DBA

1 Answers  

---

how can a session indicate its interest in receiving alerts?

1 Answers   Oracle,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---