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

What is the difference between Datapump & export/import?

2 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

how can you initialize log miner?

0 Answers   Oracle,

---

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

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

3 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---