Question 1 To explicitly start a transaction, you code the _____________________

Question

Question 1

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

Question 2

If you don’t 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 that’s included in a resource can be referred to as the resource’s ______________________________.

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, it’s called a/an ______________________________.

Question 8

A lost update occurs when

                a.           

a transaction selects data that isn’t 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 isn’t 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

Explanation / Answer

1) To explicitly start a transaction, you code the BEGIN TRANSACTION statement

2)If you don’t group statements into explicit transactions, SQL Server automatically treats each SQL statement as a separate Stages

3) To determine how many levels deep transactions are nested, you can use the @@TRANCOUNT system function.

4) SQL Server automatically avoids some concurrency problems by using lock

5) The relative amount of data that’s included in a resource can be referred to as the resource’s Database transaction unit

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

7)

If neither of two transactions can be committed because they each have a lock on a resource needed by the other, it’s called a/an Deadlock

8) A lost update occurs

d)when 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

9) A dirty read occurs when

a transaction selects data that isn’t committed by another transaction

10) Lock promotion is

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

11)  Lock escalation is

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

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.