Q. State true or false: Every cascadeless schedule is also recoverable

View solution

Q. A ___________ is one where, for each pair of transactions Ti and Tj such that Tj reads a data item previously written by Ti , the commit operation of Ti appears before the commit operation of Tj

View solution

Q. State true or false: Transactions can only run serially

View solution

Q. Which of the following are the advantages of transaction concurrency?

View solution

Q. The average time for a transaction to be completed after it has been submitted is called as __________

View solution

Q. If a schedule is equivalent to a serial schedule, it is called as a _________

View solution

Q. Which of the following is not a type of a schedule?

View solution

Q. Which of the following is a transaction isolation level as specified by SQL standard?

View solution

Q. State true or false: Serializable level may allow both serializable and non-serializable executions

View solution

Q. ________ allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction.

View solution

Q. ________ allows only committed data to be read, but does not require repeatable reads

View solution

Q. ___________ allows uncommitted data to be read

View solution

Q. State true or false: All the isolation levels disallow dirty writes

View solution

Q. When is a timestamp allotted

View solution

Q. In ___________ isolation each transaction is given its own version of the database

View solution

Q. What is the disadvantage of locking?

View solution

Q. Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction ?

View solution

Q. A transaction is delimited by statements (or function calls) of the form __________

View solution

Q. Identify the characteristics of transactions

View solution

Q. Which of the following has “all-or-none” property ?

View solution