Answer / shwetha

During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

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

2 Answers   Genpact,

---

how to restore files with rman?

0 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

What is transparent data encryption? : sql server DBA

0 Answers  

---