Explanation:Deadlock occurs when one connection is blocked and waiting for a second to complete its work 4. Which of the following occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access ?
A. Lock
B. Block
C. Deadlock
D. Exclusive lock
Answer:A
Explanation:Deadlock occurs when one connection is blocked and waiting for a second to complete its work 4. Which of the following occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access ?
A. Lock B. Block C. Deadlock D. Exclusive lock
Explanation:Lock is a done by database when any connection access a same piece of data concurrently and another is demanding for it. 5. Point out the wrong statement :