What is a database deadlock?
Practice this question from Quiz: DBMS Revision Sheet, with options and an explanation.
Question
What is a database deadlock?
Option A
A backup failure
Option B — Correct answer
A state where transactions wait on each other indefinitely
Option C
A query with no WHERE clause
Option D
A schema without indexes