Answer / Pankaj Yadav

In SQL, COMMIT and ROLLBACK are database transaction management commands. COMMIT confirms the changes made during a transaction and saves them to the database permanently. ROLLBACK undoes all changes made during a transaction, effectively reverting the database back to its state before the transaction began.

What is a deadlock and what is a live lock?

1 Answers  

---

Where is localdb stored?

1 Answers  

---

What is meant by referential integrity?

1 Answers   Blue Star,

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

Explain a join?

1 Answers  

---

Why is normalisation important?

1 Answers  

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1 Answers  

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

1 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1 Answers  

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1 Answers  

---

What is meant by dirty read?

1 Answers  

---

What is row-level compre?

1 Answers  

---