FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 15: Transaction Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

A collection of related tasks structured to accomplish a business purpose,which can be either human-oriented or computer-oriented,is known as a(n)________________.

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

One of the advantages of concurrency transparency is that relative to the results produced,a transaction takes place as if the transaction was executing alone.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

Typically,the following is not true under most operating systems control:

Typically,the most serious concurrency problem to avoid in transaction design is:

At checkpoint time:

A ________is common data that multiple users try to change.Without adequate concurrency control,users may interfere with each other on ______s.

Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the deferred update mode and completes after a checkpoint.The system crashes after the checkpoint.What should the recovery procedure perform to make sure the transaction completes as desired?

Which of the following problems is not caused by insufficient concurrency control?

Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode and completes after a checkpoint but before a system failure.The system crashes after the checkpoint.What should the recovery procedure perform to make sure the transaction completes as desired?

Consider a transaction that updates each of the 100 employees' salaries in a table (there is one row per employee) under the immediate update mode and completes before a checkpoint.The system crashes after the checkpoint.What should the recovery procedure perform to make sure the transaction completes as desired?

The transaction property of being ________ means that transactions do not interfere with each other except in allowable ways.A transaction should never overwrite changes made by another transaction.In addition,a transaction may be restricted from interfering in other ways such as not viewing the temporary changes made by other transactions.

SQL:2003 provides for a SAVEPOINT statement which establishes an intermediate point in a transaction that can be used to perform a partial rollback of the transaction.

To restore a database using the immediate update approach,both undo and redo operations may be necessary,whereas with the deferred update approach only redo operations are used.

A type of lock usually used on a large database item,such as a table,to alleviate blocking when locking coarse items is called a(n)_________________.

Which one of the following is the least likely to be viewed as a transaction?

Locking Granularity: the size of the database item locked.Locking granularity is a trade-off between waiting time (amount of concurrency permitted)and overhead (number of locks held).

A hot spot is common data that multiple users try to change simultaneously.

With the _____________________ approach,database updates are written to disk when they occur,but only after the corresponding log updates have been written.

A measure of the amount of work performed by a DBMS is the number of transactions processed per time unit.This measure is known as _____________________.

Dividing an application program into several transactions usually: