Answer / Shyam Ji Goswami

Isolation levels in SQL Server define how transactions interact with concurrent transactions. There are six isolation levels, each providing different levels of consistency and performance:nn1) Serializable: Ensures the highest level of data consistency by executing transactions sequentially.n2) Snapshot: Allows a transaction to see a snapshot of the database as it was when the transaction started.n3) Repeatable Read: Enforces consistent reads for a transaction, even if other transactions modify the same data.n4) Read Committed: Only allows a transaction to see data committed before it started.n5) Read Uncommitted: Allows a transaction to see uncommitted changes made by other transactions (not recommended due to potential inconsistencies).n6) Accessible (or no lock): Does not support any isolation, and concurrent transactions can interfere with each other (also not recommended).

How are the unique and primary key constraints different?

1 Answers  

---

How to remove duplicate rows from table except one?

0 Answers  

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---

Explain the phases a transaction has to undergo?

1 Answers  

---

Explain what are page splits? : SQL Server Architecture

1 Answers  

---

Characterize join and name diverse sorts of joins?

1 Answers  

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1 Answers  

---

How do I find the sql server version?

0 Answers  

---

How do database indexes work?

1 Answers  

---

How secure is sql server database?

1 Answers  

---

What is bcnf normalization form?

1 Answers  

---