Similar Collections

.

questions

Title
With regards to transaction processing, any DBMS should be capable of:
What is ACID properties of Transactions
Database locking concept is used to solve the problem of
A lock that allows concurrent transactions to access different rows of the same table is known as a
A transaction completes its execution is said to be
A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set
The deadlock state can be changed back to stable state by using _____________ statement
What are the ways of dealing with deadlock
When transaction Ti requests a data item currently held by Tj
When transaction Ti requests a data item currently held by Tj
The deadlock in a set of transaction can be determined by
A deadlock exists in the system if and only if the wait-for graph contains a ___________
Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
__________ rollback requires the system to maintain additional information about the state of all the running transactions
Which of these is data type long literal
Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read
A transaction for which all committed changes are permanent is called
In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed
Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction
A transaction may not always complete its execution successfully. Such a transaction is termed
total questions: 143

Questions

143

Views

1724

Best Answers

299

Points

5