Exam 10: Transaction Management and Concurrency Control

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.

(Multiple Choice)

4.9/5

(34)

Question 41

The interleaves the execution of database operations to ensure serializability.

(Short Answer)

4.7/5

(34)

Question 42

If T1 has not unlocked data item Y, T2 cannot begin; if T2 has not unlocked data item X, T1 cannot continue. Consequently, T1 and T2 each wait for the other to unlock the required data item. Such a deadlock is also known as a(n) _____.

(Short Answer)

4.8/5

(31)

Question 43

Most multiuser automatically initiate and enforce locking procedures, where all locking information is managed by the lock manager.

(Essay)

4.8/5

(44)

Question 44

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

(Short Answer)

4.9/5

(42)

Question 45

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

(Short Answer)

4.7/5

(38)

Question 46

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

(True/False)

4.9/5

(37)

Question 47

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

(True/False)

4.8/5

(30)

Question 48

In the optimistic approach, during the phase, changes are permanently applied to the database.

(Multiple Choice)

4.9/5

(27)

Question 49

occurs when a transaction accesses data before and after one or more other transactions finish working with such data.

(Multiple Choice)

4.8/5

(37)

Question 50

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

(True/False)

4.9/5

(27)

Question 51

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

(True/False)

4.9/5

(29)

Question 52

A(n) lock exists when concurrent transactions are granted read access on the basis of a common lock.

(Multiple Choice)

4.9/5

(34)

Question 53

A(n) condition occurs when two or more transactions wait for each other to unlock data.

(Multiple Choice)

4.7/5

(42)

Question 54

A occurs when two or more transactions wait for each other to unlock data.

(Multiple Choice)

4.9/5

(36)

Question 55

The multiuser DBMS must implement controls to ensure serializability and isolation of transactions, in addition to atomicity and durability, in order to guard the database's consistency and integrity.

(True/False)

4.7/5

(38)

Question 56

can take place at any of the following levels: database, table, page, row, or field.

(Short Answer)

4.8/5

(35)

Question 57

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

(Short Answer)

4.9/5

(31)

Question 58

The serializable isolation level is the least restrictive level defined by the ANSI SQL standard.

(True/False)

4.8/5

(28)

Question 59

What are the three basic techniques to control deadlocks?

(Essay)

4.9/5

(41)

Question 60

Showing 41 - 60 of 85

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.

The interleaves the execution of database operations to ensure serializability.

If T1 has not unlocked data item Y, T2 cannot begin; if T2 has not unlocked data item X, T1 cannot continue. Consequently, T1 and T2 each wait for the other to unlock the required data item. Such a deadlock is also known as a(n) _____.

Most multiuser automatically initiate and enforce locking procedures, where all locking information is managed by the lock manager.

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

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

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

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

In the optimistic approach, during the phase, changes are permanently applied to the database.

occurs when a transaction accesses data before and after one or more other transactions finish working with such data.

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

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

A(n) lock exists when concurrent transactions are granted read access on the basis of a common lock.

A(n) condition occurs when two or more transactions wait for each other to unlock data.

A occurs when two or more transactions wait for each other to unlock data.

The multiuser DBMS must implement controls to ensure serializability and isolation of transactions, in addition to atomicity and durability, in order to guard the database's consistency and integrity.

can take place at any of the following levels: database, table, page, row, or field.

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

The serializable isolation level is the least restrictive level defined by the ANSI SQL standard.

What are the three basic techniques to control deadlocks?

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters