How do you get Deadlock in Sql?
Back to QuestionsDeadlock occurs by concurrently running the same resources that access the same information in transaction
Deadlock occurs by concurrently running different resources that access the same information in transaction
Deadlock occurs by concurrently running same resources that access the different information in transaction.
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