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

Q. The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as

View solution