Update locks are said to be comparable to _______ locks.
Update locks are said to be comparable to _______ locks.
A transaction log backup method is used to back up the transaction log operations that are not shown in a _______backup copy of the database
A transaction log backup method is used to back up the transaction log operations that are not shown in a _______backup copy of the database
Database ________ is concerned with the restoring of the database to an accurate state in the occurrence of a failure
Database ________ is concerned with the restoring of the database to an accurate state in the occurrence of a failure
In case of ______ phase, all locks are released by a transaction
In case of ______ phase, all locks are released by a transaction
In case of_________ phase, all necessary locks are attained by a transaction without releasing data.
In case of_________ phase, all necessary locks are attained by a transaction without releasing data.
The _________lock is followed by a transaction if all lock requests occur prior to the first unlock operation inside the transaction
The _________lock is followed by a transaction if all lock requests occur prior to the first unlock operation inside the transaction
When deferred write or deferred update is used by the recovery process, the transaction operations do not update the _______ database instantly
When deferred write or deferred update is used by the recovery process, the transaction operations do not update the _______ database instantly
The _____ table signifies a relation that relates database elements with information regarding locking
The _____ table signifies a relation that relates database elements with information regarding locking
The term “Database Element” points to various _______ in the database
The term “Database Element” points to various _______ in the database
_______ Locks are utilised for incrementing & decrementing stored values
_______ Locks are utilised for incrementing & decrementing stored values
The rules followed in case of two phases locking protocol are given below
1) Two transactions cannot comprise inconsistent locks
2) .No unlock operation can be performed before a lock operation in the similar transaction.
The rules followed in case of two phases locking protocol are given below
1) Two transactions cannot comprise inconsistent locks
2) .No unlock operation can be performed before a lock operation in the similar transaction.
A _____is used by the transaction to reject data access to other transactions and thus avoid inaccurate updates
A _____is used by the transaction to reject data access to other transactions and thus avoid inaccurate updates
______ is considered as a temporary storage part available in primary memory.
______ is considered as a temporary storage part available in primary memory.
In ________ lock only one user is permitted to update a specific part of data
In ________ lock only one user is permitted to update a specific part of data
Write-ahead protocol makes sure that transaction logs are always written _______ any database data that are really updated
Write-ahead protocol makes sure that transaction logs are always written _______ any database data that are really updated
_______ approach grants longest waiting request. It does not provide starvation.
_______ approach grants longest waiting request. It does not provide starvation.
In case of differential backup, only the ____ variations that are performed on the database are copied.
In case of differential backup, only the ____ variations that are performed on the database are copied.
In_________If there is a U lock waiting for upgrading an X lock, grant that first.
In_________If there is a U lock waiting for upgrading an X lock, grant that first.
________ is an operation where all the updated buffers are written to the disk by the DBMS.
________ is an operation where all the updated buffers are written to the disk by the DBMS.
Transactions with unexpected read write locks can make use of_______Locks
Transactions with unexpected read write locks can make use of_______Locks