Question 1

To explicitly start a transaction, you code the ______________________________ statement.

Question 2

If you dont group statements into explicit transactions, SQL Server automatically treats each SQL statement as a separate __________________.

Question 3

To determine how many levels deep transactions are nested, you can use the ______________________________ system function.

Question 4

SQL Server automatically avoids some concurrency problems by using ______________________________.

LOCKS

Question 5

The relative amount of data thats included in a resource can be referred to as the resources ______________________________.

Question 6

A lock that allows only one transaction to access a resource is called a/an ______________________________ lock.

Question 7

If neither of two transactions can be committed because they each have a lock on a resource needed by the other, its called a/an ______________________________.

Question 8

A lost update occurs when

a.

a transaction selects data that isnt committed by another transaction

b.

two SELECT statements that select the same data get different values because another transaction has updated the data in the time between the two statements

c.

two transactions select the same row and then update the row based on the values originally selected

d.

you perform an update on a set of rows when another transaction is performing an insert that affects one or more rows in that same set of rows

Question 9

A dirty read occurs when

a.

you perform an update on a set of rows when another transaction is performing an insert that affects one or more rows in that same set of rows

b.

a transaction selects data that isnt committed by another transaction

c.

two transactions select the same row and then update the row based on the values originally selected

d.

two SELECT statements that select the same data get different values because another transaction has updated the data in the time between the two statements

Question 10

Lock promotion is

a.

the conversion of an exclusive lock to an intent lock

b.

the conversion of several finer-grained locks to a single coarse-grain lock

c.

the conversion of a less exclusive lock to a more exclusive lock

d.

the conversion from a less restrictive transaction isolation level to a more restrictive transaction isolation level

Question 11

Lock escalation is

a.

the conversion of an exclusive lock to an intent lock

b.

the conversion from a less restrictive transaction isolation level to a more restrictive transaction isolation level

c.

the conversion of several finer-grained locks to a single coarse-grain lock

d.

the conversion of a less exclusive lock mode to a more exclusive lock mode