Q. Execution of translation in isolation preserves the _________ of a database

View solution

Q. Which of the following is not a property of a transaction?

View solution

Q. Which of the following systems is responsible for ensuring durability?

View solution

Q. Which of the following systems is responsible for ensuring isolation?

View solution

Q. State true or false: Information residing in the volatile storage does not usually survive system crashes

View solution

Q. A transaction that has not been completed successfully is called as _______

View solution

Q. Which of the following is not a transaction state?

View solution

Q. The execution sequences in concurrency control are termed as ________

View solution

Q. The scheme that controls the interaction between executing transactions is called as _____

View solution

Q. I and J are _________ if they are operations by different transactions on the same data item, and at least one of them is a write operation.

View solution

Q. If a schedule S can be transformed into a schedule S’ by a series of swaps of non-conflicting instructions, then S and S’ are

View solution

Q. A schedule is __________ if it is conflict equivalent to a serial schedule.

View solution

Q. The set of ________ in a precedence graph consists of all the transactions participating in the schedule

View solution

Q. A ___________of the transactions can be obtained by finding a linear order consistent with the partial order of the precedence graph.

View solution

Q. State true or false: If I = read(Q) and J = read(Q) then the order of I and J does not matter.

View solution

Q. State true or false: If I = read(Q) and J = write(Q) then the order of I and J does not matter.

View solution

Q. Which of the following is the most expensive method?

View solution

Q. A transaction that performs only one operation is called as a _________

View solution

Q. The phenomenon in which one failure leads to a series of transaction rollbacks is called as ________

View solution

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

View solution