Explain how to use transactions efficiently : transact sql

1021

---

How do you determine the current isolation level? : Transact sql

1210

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1067

---

What is the default isolation level in sql server? : Transact sql

1091

---

Define concurrency control. : Transact sql

1240

---

What is pessimistic concurrency control? : Transact sql

1143

---

How to use transactions efficiently : transact sql

1121

---

Explain locks? : Transact sql

1062

---

What is the least restrictive isolation level? : Transact sql

1112

---

What is optimistic concurrency control? : Transact sql

1036

---

What is the most restrictive isolation level? : Transact sql

1130

---

Explain isolation levels. : Transact sql

1114

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

1024

---

what is the primary use of the model database? : Sql server administration

1104

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

1010

---