Youre getting high busy buffer waits - how can you find whats causing it?

1 Answers  

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

0 Answers  

---

what are Triggers?

7 Answers   TCS,

---

What are synonyms used for ?

3 Answers  

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

0 Answers   Wipro,

---

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

0 Answers  

---

Please explain oracle left join with an example?

0 Answers  

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

Explain an integrity constrains?

0 Answers  

---

what is shell?

2 Answers   Microsoft,

---

Give the constructs of a package, function or a procedure.

0 Answers  

---