Answer / Guddu Kumar

Commit and rollback are SQL operations used to manage transactions. A COMMIT operation finalizes a transaction, making all changes permanent. A ROLLBACK operation undoes all changes made within a transaction, effectively reverting the database back to its state before the transaction started.

What is the command used to check locks in microsoft sql server?

1 Answers  

---

What is meant by dirty read?

1 Answers  

---

Explain the properties of a relational table?

1 Answers  

---

What is the importance of three tier architecture?

1 Answers   QuestPond,

---

Do you know what are the properties of the relational tables?

1 Answers  

---

Will sql server 2005 allow you to reduce the size of a column?

1 Answers  

---

What are the purposes and advantages stored procedure?

1 Answers  

---

Is a primary key unique?

1 Answers  

---

What is meant by Active-Passive and Active-Active clustering setup?

1 Answers  

---

what is dbcc? : Sql server database administration

1 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1 Answers  

---

What are rows and columns?

1 Answers  

---