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.

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

Explain materialized views and how they are used.

0 Answers  

---

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

2 Answers  

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

What is dbcc? : sql server DBA

0 Answers  

---