Answer / sudarsan

check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.

Answer / sreeramch9

Check Point(CKPT) is a Background Processor, which update latest SCN to datafile header and control file by using online redolog file.

Answer / kittu_chintu2005

A checkpoint is a mandatory background process which signals to DBWn

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

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

2 Answers  

---

what is logical system in sap basis

0 Answers  

---

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

0 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

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

0 Answers  

---