Explain how to use transactions efficiently : transact sql

1017

---

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

1206

---

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

1063

---

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

1089

---

Define concurrency control. : Transact sql

1236

---

What is pessimistic concurrency control? : Transact sql

1136

---

How to use transactions efficiently : transact sql

1116

---

Explain locks? : Transact sql

1058

---

What is the least restrictive isolation level? : Transact sql

1107

---

What is optimistic concurrency control? : Transact sql

1032

---

What is the most restrictive isolation level? : Transact sql

1128

---

Explain isolation levels. : Transact sql

1109

---

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

1019

---

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

1097

---

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

---