Answer / Mohit Singh Chauhan

SQL Server provides several cursor lock types to control the level of concurrency and isolation during cursor operations. The available lock types are:
1. READ_UNCOMMITTED: Allows dirty reads, non-repeatable reads, and phantom reads.
2. READ_COMMITTED: Prevents dirty reads but allows non-repeatable reads and phantom reads.
3. REPEATABLE_READ: Prevents non-repeatable reads but allows phantom reads.
4. SERIALIZABLE: Prevents both non-repeatable reads and phantom reads, ensuring serializable isolation level.

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

What is difference between equi join and inner join?

1 Answers  

---

What is the template in sql?

1 Answers  

---

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

---

How to create a stored procedure with a statement block in ms sql server?

1 Answers  

---

How will you hide an attribute? : sql server analysis services, ssas

1 Answers  

---

Can you tell me about the concept of ER diagrams?

1 Answers  

---

How to create an multi-statement table-valued function?

1 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

Explain about local stored procedure?

1 Answers  

---

What is 2nf normalization form?

1 Answers  

---

Will the writetext statement activate a trigger?

1 Answers  

---