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.

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

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

2 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

What is the default fill factor value? : sql server DBA

0 Answers  

---