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 transparent data encryption? : sql server DBA

0 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

Can we take incremental backups in datapump?

1 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

Explain the use of table functions.

1 Answers  

---

What is the default fill factor value? : sql server DBA

0 Answers  

---