Question 1

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

Accepted Answer

A) True 
 B)False

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

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

Question 4

The ____________________ interleaves the execution of database operations to ensure serializability.

Accepted Answer

The answer of The ____________________ interleaves the execution of database...

Question 5

Lock ____ indicates the level of lock use.

Accepted Answer

A)   granularity
B)   shrinking
C)   growing
D)   serializabilityE) None of the above
F) A) and B)

Question 6

A ____ lock locks the entire diskpage.

Accepted Answer

A)   transaction-level
B)   table-level
C)   page-level
D)   row-levelE) C) and D)
F) B) and C)

Question 7

What is a rule that applies to the two-phase locking protocol?

Accepted Answer

A)   Two transactions cannot have conflicting locks.
B)   No unlock operation can precede a lock operation in a different transaction.
C)   No data is affected until all locks are released.
D)   No data is affected until the transaction is in its locked position.E) B) and C)
F) A) and C)

Question 8

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

Accepted Answer

A)   serializability and durability
B)   atomicity and isolation
C)   serializability and isolation
D)   atomicity and serializabilityE) C) and D)
F) A) and B) C

Question 9

The transaction recovery write-ahead-log protocol ensures that transaction logs are always written before any database data are actually updated.

Accepted Answer

A) True 
 B)False  True

Question 10

____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Accepted Answer

A)   Serializability
B)   Atomicity
C)   Isolation
D)   Time stampingE) All of the above
F) A) and C)

Question 11

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?

Accepted Answer

A)   Five SQL statements are executed.
B)   The end of a program is successfully reached.
C)   The program is abnormally terminated.
D)   The database is shut down for maintenance.E) B) and D)
F) C) and D)

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

To determine the appropriate order of the operations,the scheduler bases its actions on concurrency control algorithms,such as ____________________ or time stamping methods.

Accepted Answer

locking

Question 14

A shared lock produces no conflict as long as all the concurrent transactions are read-write only.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)   growing
B)   shrinking
C)   locking
D)   unlockingE) None of the above
F) A) and B)

Question 17

A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed.

Accepted Answer

A)   database-level
B)   table-level
C)   page-level
D)   row-levelE) B) and C)
F) A) and D)

Question 18

____ requires that all operations of a transaction be completed.

Accepted Answer

A)   Specificity
B)   Atomicity
C)   Durability
D)   Time stampingE) C) and D)
F) None of the above

Question 19

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.

Accepted Answer

A)   read
B)   validation
C)   write
D)   sharedE) None of the above
F) B) and D)

Question 20

____ are required to prevent another transaction from reading inconsistent data.

Accepted Answer

A)   Locks
B)   Schedules
C)   Stamps
D)   LogsE) B) and D)
F) A) and B)

Exam 10: Transaction Management and Concurrency Control

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

Correct AnswerverifiedShow Answer

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

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

The ____________________ interleaves the execution of database operations to ensure serializability.

Correct AnswerverifiedShow Answer

Lock ____ indicates the level of lock use.

Correct AnswerverifiedShow Answer

A ____ lock locks the entire diskpage.

Correct AnswerverifiedShow Answer

What is a rule that applies to the two-phase locking protocol?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

The transaction recovery write-ahead-log protocol ensures that transaction logs are always written before any database data are actually updated.

Correct AnswerverifiedTrue

____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To determine the appropriate order of the operations,the scheduler bases its actions on concurrency control algorithms,such as ____________________ or time stamping methods.

Correct Answerverifiedlocking

A shared lock produces no conflict as long as all the concurrent transactions are read-write only.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A ____ lock prevents the use of any tables in the database from one transaction while another transaction is being processed.

Correct AnswerverifiedShow Answer

____ requires that all operations of a transaction be completed.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

____ are required to prevent another transaction from reading inconsistent data.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
locking

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified