It is a database questions talks about transactions.

PL-phase locking

BTO- Basic Timestamp Ordering

3.(8 points) Consider the following actions taken by transaction T1 on databases X and Y items: R(X), W(X), R(Y), W(Y).

(a)Give an example of another transaction T2 that, if run concurrently to transaction T1 without some form of concurrency control, could interfere with T1.

(b)Explain how the use of Strict 2PL would prevent interference between the two transactions.

4. What is the CAP theorem? Furthermore, what are the similarities and differences between consistency used in CAP versus Consistency used in ACID?