what are the differences between network and hierarchical database model?

1135

---

Mention how deadlock can be resolved?

973

---

What is index hunting?

1212

---

When does checkpoint occur?

901

---

What is an entity-relationship model?

953

---

What does fill factor concept mean with respect to indexes?

939

---

Explain the term specialization.

865

---

What do you understand by correlated subqueries in dbms?

977

---

Mention few case manipulation functions in sql

992

---

what are the acid properties in dbms?

1035

---

What are the differences between hash join, merge join and nested loops?

1015

---

Explain the term generalization.

994

---

What is concurrency control?

1039

---

What do you understand by sub-queries in sql?

958

---

What is a deadlock and mention how it can be resolved?

873

---