FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Transaction Management and Concurrency Control

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

A transaction is a unit of work that must be either entirely completed or aborted.

A) timed
B) practical
C) logical
D) physical

E) A) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

ensure that a disk physical failure will not impair the DBMS's ability to recover data.

Correct Answer

verified

Redundant ...

View Answer

Show Answer

Question 43

True/False

Review LaterAdd Note

Durability requires that all portions of the transaction must be treated as a single, logical unit of work in which all operations are applied and completed to produce a consistent database.

In a page-level lock, the DBMS will lock an entire diskpage.

A(n) specifically reserves access to the transaction that locked the object.

Explain the transaction log. What is its function?

The transaction recovery write-ahead-log protocol ensures that transaction logs are always written before any database data are actually updated.

All transactions must display .

Although the DBMS is designed to recover a database to a previous consistent state when an interruption prevents the completion of a required set of transactions, the transactions themselves are defined by the end user or programmer and must be correct.

A lock prevents the use of any tables in the database from one transaction while another transaction is being processed.

A(n) lock has only two stages (0 and 1) .

The scheduler establishes the order in which the operations within concurrent transactions are executed.

What is transaction isolation and why it is important?

means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

The ANSI has defined standards that govern SQL database transactions. Transaction support is provided by two SQL statements: and ROLLBACK.

The scheduler's main job is to create a(n) of a transaction's operation, in which the interleaved executions of transactions yield the same results as if the transactions were executed in serial order.

Serializability means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

An optimistic approach is based on the assumption that the majority of the database operations do not conflict.

The information stored in the is used by the DBMS for a recovery requirement triggered by a ROLLBACK statement, a program's abnormal termination, or a system failure such as a network discrepancy or a disk crash.

The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event.