Q. The property of DBMS which ensures whether the hundreds of applications are executed, each transaction must be executed in isolation is classified as

View solution

Q. If a transaction has obtained a __________ lock, it can read but cannot write on the item

View solution

Q. If a transaction has obtained a ________ lock, it can both read and write on the item

View solution

Q. A transaction can proceed only after the concurrency control manager ________ the lock to the transaction

View solution

Q. If a transaction can be granted a lock on an item immediately in spite of the presence of another mode, then the two modes are said to be ________

View solution

Q. A transaction is made to wait until all ________ locks held on the item are released

View solution

Q. State true or false: It is not necessarily desirable for a transaction to unlock a data item immediately after its final access

View solution

Q. The situation where no transaction can proceed with normal execution is known as ________

View solution

Q. The protocol that indicates when a transaction may lock and unlock each of the data items is called as __________

View solution

Q. If a transaction Ti may never make progress, then the transaction is said to be ____________

View solution

Q. The two phase locking protocol consists which of the following phases?

View solution

Q. If a transaction may obtain locks but may not release any locks then it is in _______ phase

View solution

Q. If a transaction may release locks but may not obtain any locks, it is said to be in ______ phase

View solution

Q. A system is in a _______ state if there exists a set of transactions in which every transaction is waiting for another transaction in the set.

View solution

Q. Which of the following is not a method in deadlock handling

View solution

Q. Deadlocks can be prevented using

View solution

Q. State true or false: Wait die scheme is a non-preemptive technique

View solution

Q. Lock timeouts have which of the following advantages?

View solution

Q. The _________ graph describes deadlocks precisely

View solution

Q. How do we generally recover from a deadlock?

View solution