Answer Posted / 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 initialize log miner?

1186

---

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

2532

---

What is the importance of a recovery model? : sql server DBA

1080

---

Explain about your sql server dba experience? : sql server DBA

1157

---

how can you schedule a job in database?

1192

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2013

---

how can you get actual data change values from previous transactions in oracle?

1138

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1091

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2406

---

How do you trace the traffic hitting a sql server? : sql server DBA

1628

---

Why would you call update statistics? : sql server DBA

1039

---

How can you control the amount of free space in your index pages? : sql server DBA

1373

---

How would you go about verifying the network name that the local_listener is currently using?

3271

---

what are the benefits of flashback feature?

1089

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2343

---