SQL Deadlock in Structure Query Language

Question

Illustrate the SQL Deadlock in Structure Query Language?

Answer 1

Deadlock:

It is a unique situation within a multi user system which causes two or more users to wait indefinitely for a locked resource. Initially user needs a resource locked through the second user and the second user requires a resource locked through the first user. To ignore dead locks, ignore using exclusive table lock and when using, use this in similar sequence and use Commit often to release locks.