Give the syntax of exception handling used in DBMS?

1199

---

What are different types of blocks used in stored procedure?

1130

---

What are different types of clusters present?

1079

---

What is the difference between a stored procedure and a query?

1089

---

Differentiate between unique key and foreign key?

1011

---

How do you pass parameter in stored procedure?

1208

---

What are indexes in oracle?

1090

---

What is the relationship that exists inside in E-R diagram?

1089

---

Write a query to get maximum and second maximum in oracle?

1045

---

Write a query to retrieve for many to many relationships?

1003

---

How to produce such kind of file?

1105

---

What is a trace file?

1074

---

What is the purpose of TNS?

1028

---

What are the disadvantages of primary key and foreign key in SQL?

1109

---

Write a SQL command to insert and update only a particular field?

1110

---