Multiple Choice
Which of the following will cause a deadlock?
A) Transaction T1 requests an exclusive lock on data A at the same time as transaction T2
B) Simultaneously, transaction T2 places an exclusive lock on data B, then requests one on data A
C) Transaction T1 places an exclusive lock on data A, then transaction T2 requests a shared lock on data A
D) Transaction T1 places an exclusive lock on data A, then requests one on data
E) Transaction T1 and T2 modify data A without any lock
Correct Answer:

Verified
Correct Answer:
Verified
Q3: Julia has a lock on the savings
Q4: When an update to the database takes
Q5: The optimistic concurrency control approach may delay
Q6: A(n)_ is an inconsistent retrieval problem which
Q7: Julia has a shared lock on the
Q9: Some transactions have tentative actions that can
Q10: Which of the following is an example
Q11: Consider a transaction that updates each of
Q12: Depending on the DBMS,checkpoints:<br>A) Are performed when
Q13: Any number of users can hold a