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 31

True/False

Review LaterAdd Note

Review Later

Incomplete or improper transactions can have a devastating effect on database integrity.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Essay

Review LaterAdd Note

Review Later

What are database checkpoints?

Correct Answer

verified

Database checkpoints are operations in w...

View Answer

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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.

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

In a heavily used database management system (DBMS),the prevention and detection of constitutes an important DBMS function.

requires that all operations of a transaction be completed.

Uniqueness ensures that no equal time stamp values can exist,and ensures that time stamp values always increase.

A scheduler facilitates data isolation to ensure that two transactions do not update the same data element at the same time.

The .occurs when two concurrent transactions,T1 and T2,are updating the same data element and one of the updates is lost.

A lock locks the entire diskpage.

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

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.

Most real-world database transactions are formed by only one database request.

In the optimistic approach,during the phase,a transaction scans the database,executes the needed computations,and makes the updates to a private copy of the database values.

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

Timestamps must only have the single property of uniqueness.

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

Atomicity indicates the permanence of the database's consistent state.

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

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