Answer / gogune suresh kumar

All data changes to the database are stored in redo-log
buffers.

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

3 Answers   TCS,

---

What view would you use to look at the size of a data file?

3 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

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

4 Answers  

---

what is rebuild index??

2 Answers   IBM, Sapient,

---