Explain materialized views and how they are used.

0 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

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  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

How would you determine who has added a row to a table?

4 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

what is meant by gateway

1 Answers   IBM,

---