Question 1

As long as two transactions, T1 and T2, access data, there is no conflict, and the order of execution is irrelevant to the final outcome.

Accepted Answer

A)   shared
B)   common
C)   unrelated
D)   lockedE) A) and D)
F) B) and C)

Question 2

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 semantically correct.

Accepted Answer

A) True 
 B)False

Question 3

If a(n) is issued before the termination of a transaction, the DBMS will restore the database only for that particular transaction, rather than for all transactions, in order to maintain the durability of the previous transactions.

Accepted Answer

The answer of If a(n) is issued before the termination...

Question 4

A lock guarantees the open use of a data item to multiple transactions.

Accepted Answer

A) True 
 B)False

Question 5

A consistent database state is .

Accepted Answer

A)   one in which all tables have foreign keys
B)   one in which all data integrity constraints are satisfied
C)   one in which all tables are normalized
D)   one in which all SQL statements only update one table at a timeE) C) and D)
F) B) and D)

Exam 10: Transaction Management and Concurrency Control

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 semantically correct.

Correct Answer
verified

A consistent database state is .

Correct Answer
verified

If a(n) is issued before the termination of a transaction, the DBMS will restore the database only for that particular transaction, rather than for all transactions, in order to maintain the durability of the previous transactions.

Correct Answer
verified

A lock guarantees the open use of a data item to multiple transactions.

Correct Answer
verified

As long as two transactions, T1 and T2, access data, there is no conflict, and the order of execution is irrelevant to the final outcome.

Correct Answer
verified

Exam 10: Transaction Management and Concurrency Control

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 semantically correct.

Correct AnswerverifiedShow Answer

A consistent database state is .

Correct AnswerverifiedShow Answer

If a(n) is issued before the termination of a transaction, the DBMS will restore the database only for that particular transaction, rather than for all transactions, in order to maintain the durability of the previous transactions.

Correct AnswerverifiedShow Answer

A lock guarantees the open use of a data item to multiple transactions.

Correct AnswerverifiedShow Answer

As long as two transactions, T1 and T2, access data, there is no conflict, and the order of execution is irrelevant to the final outcome.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified