Answer / Amar Jeet Singh

A deadlock occurs in a database system when two or more transactions are blocked, waiting for each other to release resources that they need. To resolve a deadlock, you can use various techniques such as deadlock detection, prevention, or recovery.

What are the Common SQL Functions Used for Data Aggregation?

1 Answers  

---

Define atomicity and aggregation.

1 Answers  

---

what is difference between clustering and mirroring?

2 Answers   Religare,

---

State at least four kinds of indexing?

1 Answers   Amazon, iNautix,

---

What are the steps to follow when preparing to create a table?

1 Answers  

---

How to lock records in a table?

1 Answers  

---

Explain about the properties of cursors?

1 Answers  

---

Is database a data structure?

1 Answers  

---

What are the parts of a table?

1 Answers  

---

Which database is best for storing images?

1 Answers  

---

What are the steps involved in Database Shutdown ?

1 Answers  

---

How many records can a database hold?

1 Answers  

---