Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
A) It will result in a deadlock situation.
B) It will immediately be granted.
C) It will immediately be reject
Correct Answer:
Verified
Q3: A primary key when combined with a
Q4: The set of permitted value for each
Q5: The airline reservation system, the enables are
Q6: A functional dependency of the form X?Y
Q7: In transactions, in ACID property A stands
Q9: A schedule S of n transactions is
Q10: In two-phase locking protocol.
A)All unlocking operations precede
Q11: Transaction timestamp is:
A)Not unique for each transaction
B)Larger
Q12: The granularity of a database item can
Q13: If the complete execution of the transaction(s)
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents