Let R_i(z) and W_i(z) denote reac and write operations on a data element z by a transaction T_i, respectively. Consider the schedule S with four transactions.

S : R₄(x), R₂(x), R₃(x), R₁(y), W₁(y), W₂(x), W₃(y), R₄(y)

Which one of the following serial schedules is conflict equivalent to S?

Consider the following two statements about database transaction schedules:

I. Strict two-phase locking protocol generates conflict serializable schedules that are also recoverable.

II. Timestamp-ordering concurrency control protocol with Thomas Write Rule can generate view serializable schedules that are not conflict serializable.

Which of the above statements is/are TRUE?

Suppose a database schedule $$S$$ involves transactions $${T_1},\,...,\,{T_n}.$$ Construct the precedence graph of $$S$$ with vertices representing the transactions and edges representing the conflicts. If $$S$$ is serializable, which one of the following orderings of the vertices of the precedence graph is guaranteed to yield a serial schedule?

Which one of the following is NOT a part of the $$ACID$$ properties of database transactions?