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

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 B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) read
B) validation
C) write
D) shared

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

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

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

requires that all operations of a transaction be completed.

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

What are database checkpoints?

A lock locks the entire diskpage.

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

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

Timestamps must only have the single property of uniqueness.

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.

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

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

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.

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