What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

What is sap sql anywhere?

0 Answers  

---

Is merge a dml statement?

0 Answers  

---

Why do we use joins?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

---

What are the disadvantages of not performing database normalization?

0 Answers  

---

What is correlated sub-query?

7 Answers   Oracle,

---

Why is there a need for sqlcode and sqlerrm variables?

0 Answers  

---

How many sql commands are there?

0 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

---

Explain spool.

0 Answers  

---