A transaction can either _____

When you use transactions, you put locks on data that is

pending for _____change to the database.

You could lock anything from a single row up to the entire

database.

A transaction is characterized by four properties,

they are

A transaction is ______ if it's regarded as a single action rather than a collection of separate operations.

The transaction should leave the database in a

_____ state, whether or not it completed successfully.

Data modifications that occur within a successful transaction are kept permanently within the system regardless of what else occurs. Transaction logs are maintained so that should a failure occur the database can be restored to its original state before the failure

Every transaction has a well-defined boundary; that is, it is isolated from another transaction. One transaction shouldn't affect other transactions running at the same time.

Identify Transact-SQL statements

_____________those in which you explicitly control

when the transaction begins and when it ends.

When you connect to a database using SQL Server

Management Studio and execute a DML query, the changes are automatically saved. This is known as____

_________mode is the default transaction management

mode of SQL Server.