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 21

True/False

Review LaterAdd Note

Review Later

The last step in the write-through technique recovery procedure is to identify the last checkpoint in the transaction log.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

A lock allows concurrent transactions to access different rows of the same table.

A) database-level
B) table-level
C) page-level
D) row-level

E) B) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

The objective of control is to ensure the serializability of transactions in a multiuser database environment.

Lock indicates the level of lock use.

When using an optimistic approach, during the read phase, a transaction reads the database, executes the needed computations, and makes the updates to a private copy of the database values.

Timestamps must only have the single property of uniqueness.

The approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.

A diskpage, or page, is the equivalent of a .

ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a COMMIT?

When using an optimistic approach, during the write phase, the transaction is validated to ensure that the changes made will not affect the integrity and consistency of the database.

A lock locks the entire table preventing access to any row by a transaction while another transaction is using the table.

The reason for the different levels of isolation is to increase transaction concurrency.

A lock locks the entire diskpage.

The rule states that only one transaction at a time can own an exclusive lock on the same object.

ANSI defines four events that signal the end of a transaction. Of the following events, which is defined by ANSI as being equivalent to a ROLLBACK?

requires that all operations of a transaction be completed.

A(n) phase in a two-phase lock is when a transaction releases all locks and cannot obtain any new lock.

How does a shared/exclusive lock schema increase the lock manager's overhead?

Database transaction restores a database from an inconsistent state to a previously consistent state.

A single-user database system automatically ensures of the database, because only one transaction is executed at a time.