Answer / Abhilasha Gautam

In SQL Server, `FOR AUTO_UPDATE` provides automatic updates of cursor variables when a row is fetched or updated. On the other hand, `FOR NESTED TRANSACTIONS` allows you to perform multiple transactions within the same scope, maintaining the ACID (Atomicity, Consistency, Isolation, Durability) properties.

what is database replication? : Sql server database administration

1 Answers  

---

Can we call future method from queueable?

1 Answers  

---

Describe about first three Normal forms.

1 Answers   HP,

---

How to handle error or exception in sql?

1 Answers  

---

Does hive support indexing?

1 Answers  

---

What is difference between clustered and non clustered index?

1 Answers  

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1 Answers  

---

What is instead of dml trigger?

1 Answers  

---

Why use stored procedures in sql server?

1 Answers  

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

What is the parse query button used for?

1 Answers  

---

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---