Recent questions tagged transaction-and-concurrency

If a transaction $t_{a}$ holds a lock on some data item $d$ in shared and intention-exclusive (SIX) mode, then which of the following is true for another transaction $t_{...

In transactions, a write-item $(\mathrm{X})$ command includes the following steps. Arrange the following steps in correct sequence.Copy item $(\mathrm{X})$ from the progr...

Consider concurrent execution of two transactions $T 1$ and $T 2$ in a DBMS, both of which access a data object $A$. For these two transactions to not conflict on $A$, wh...

We have a table Orders with a specific predicate range query Q: SELECT * FROM Orders WHERE Value 1000Transaction $T_1$ executes $Q$ and gets 5 rows.Transaction $T_2$ ins...

Considering the following statements:A non-serial schedule is said to be conflict serializable, if it is conflict-equivalent to some serial schedule.A non-serial schedule...

In concurrency control, phantom problem may occur, when-records are insertedrecords are deletedrecords are modifiedrecords are indexed

Match the $\textbf{LIST-I}$ with $\textbf{LIST-II}$$\begin{array}{|l|l|c|l|} \hline & \textbf{ LIST-I } & & \textbf{ LIST-II } \\ \hline \text{A.} & \text{Project Join No...

Consider the transactions $\mathrm{T}_{1}, \mathrm{~T}_{2}, \mathrm{~T}_{3}$ and the schedules $\mathrm{S}_{1}$ and $\mathrm{S}_{2}$ given below.$\begin{array}{ll} T_{1}:...

Which one of the following statements are CORRECT?Granularity is the size of data item in a database.Two operations in a schedule are said to be conflict if they belong t...