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.

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

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

3 Answers   TCS,

---

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 difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

Describe what redo logs are.

1 Answers  

---

how can you schedule a job in database?

0 Answers   Oracle,

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---