Database Management Questions: 1. Concurrency transparency would be that multipl

Question

Database Management Questions:

1. Concurrency transparency would be that multiple students could register for the same course offering at the same time, without interference from each other.

True or False

2. Julia has a shared lock on the savings account and Bill is trying to perform an action requesting an exclusive lock on the same data:

a.Bill's transaction must wait until Julia's lock is released

b.Bill's transaction must wait until Julia has read the savings account value

c.Bill's transaction is granted permission to perform the desired action and Julia's transaction must now wait

d.None of the above

Explanation / Answer

Hi,

Below are the answers-

Ans 1 - TRUE -Concurrency refers to simultaneous data access or data read and write on the same database without making any process to wait for the access.

Ans 2 - a.Bill's transaction must wait until Julia's lock is released

Regards,

Vinay Singh

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.