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 you enable a trace for a session?

1 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

What does coalescing a tablespace do?

1 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

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

1 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---