What is the difference between substr & instr functions?

1248

---

What is meant by joins?

1073

---

Can we save images in a database and if yes, how?

1083

---

What is a view and how is it different from a table?

1066

---

How will you write a query to get a 5th rank student from a table student_report?

1883

---

What are the different editions of oracle?

1127

---

What is meant by an index?

1165

---

What is meant by a deadlock situation?

1122

---

What is the difference between a primary key & a unique key?

1106

---

How can we find out the current date and time in oracle?

1105

---

What is a nested table and how is it different from a normal table?

1071

---

How is it different from a normal table?

1048

---

How does the on-delete-cascade statement work?

1136

---

What is meant by joins? List out the types of joins.

1058

---

What do you understand by database schema and what does it hold?

1244

---