Question 1

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

Accepted Answer

The answer of The ____________________ rule states that only one...

Question 2

____________________ control is important because the simultaneous execution of transactions over a shared database can create several data integrity and consistency problems.

Accepted Answer

The answer of ____________________ control is important because the simultaneous...

Question 3

Serializability 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) True 
 B)False

Question 4

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 COMMIT?

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

Question 5

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

Question 6

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

Accepted Answer

A)  Locks 
B)  Schedules 
C)  Stamps 
D)  Logs 
A)  Locks 
B)  Schedules 
C)  Stamps 
D)  Logs

Question 7

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-level 
A)  database-level 
B)  table-level 
C)  page-level 
D)  row-level

Question 8

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

Question 9

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

Accepted Answer

The answer of Database transaction ____________________ restores a database from...

Question 10

____________________-level locks are less restrictive than database-level locks, but they create traffic jams when many transactions are waiting to access the same table.

Accepted Answer

The answer of ____________________-level locks are less restrictive than database-level...

Question 11

What are the three basic techniques to control deadlocks?

Accepted Answer

Deadlock prevention. A transaction reque

Question 12

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 13

What are database checkpoints?

Accepted Answer

Database checkpoints are operations in w

Question 14

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 15

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 time 
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 time

Question 16

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

Accepted Answer

The answer of Uniqueness ensures that no equal time stamp...

Question 17

A growing phase in a two-phase lock is when a transaction acquires all the required locks without locking any data.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 serializability 
A)  serializability and durability 
B)  atomicity and isolation 
C)  serializability and isolation 
D)  atomicity and serializability

Question 20

How does a shared/exclusive lock schema increase the lock manager's overhead?

Accepted Answer

The type of lock held must be known befo

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

____________________ control is important because the simultaneous execution of transactions over a shared database can create several data integrity and consistency problems.

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

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 COMMIT?

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

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

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

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.

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

____________________-level locks are less restrictive than database-level locks, but they create traffic jams when many transactions are waiting to access the same table.

What are the three basic techniques to control deadlocks?

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

What are database checkpoints?

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.

A consistent database state is ____.

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

A growing phase in a two-phase lock is when a transaction acquires all the required locks without locking any data.

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

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

How does a shared/exclusive lock schema increase the lock manager's overhead?

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 13: Managing Transactions and Concurrency

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

____________________ control is important because the simultaneous execution of transactions over a shared database can create several data integrity and consistency problems.

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

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 COMMIT?

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

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

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

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.

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

____________________-level locks are less restrictive than database-level locks, but they create traffic jams when many transactions are waiting to access the same table.

What are the three basic techniques to control deadlocks?

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

What are database checkpoints?

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.

A consistent database state is ____.

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

A growing phase in a two-phase lock is when a transaction acquires all the required locks without locking any data.

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

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

How does a shared/exclusive lock schema increase the lock manager's overhead?

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Database and Sql Performance

Databases for Decision Support

Filters