How do you get Deadlock in Sql?

Back to Questions
A)

Deadlock occurs by concurrently running the same resources that access the same information in transaction

B)

Deadlock occurs by concurrently running different resources that access the same information in transaction

C)

Deadlock occurs by concurrently running same resources that access the different information in transaction.

 

Author Explanation :

Deadlock in sql occurs when the same information from the same resource is being accessed at this state the operation performed by the first call is executed and unless that operation is completed the same call to access the same information would be prohibited this is called deadlock state once the operation is done than the lock would be released

Answers Posted

PostedBy By: Sana Dhanani, at 03:46 AM on 23-July-2019

Answer Posted: B

Explanation: B

Result: Wrong Answer

PostedBy By: Abhishek Kumar, at 06:50 PM on 07-July-2019

Answer Posted: C

Explanation: c

Result: Wrong Answer

PostedBy By: Akhil, at 03:13 PM on 01-April-2019

Answer Posted:

Explanation: by running different resources that access the same information in transaction

Result: Wrong Answer

PostedBy By: Abdul Samad Qureshi, at 02:38 PM on 27-March-2019

Answer Posted:

Explanation: As this results in indefinite wait period.

Result: Wrong Answer

Back to Questions

© Copyright 1997 - 2019 | www.bestdotnettraining.com | www.deccansoft.com | All Rights Reserved.
 
Bestdotnet google plus
Enquiry Now