engineering computer science MCQ #886

What is a database deadlock?

engineering computer science MCQ #886

  1. Question 1

    Q1. What is a database deadlock?

    • A) A situation where two or more transactions are blocked, waiting for each other to release resources
    • B) A situation where a transaction is rolled back due to an error
    • C) A situation where a database is shut down
    • D) A situation where a database is started

    Answer: A situation where two or more transactions are blocked, waiting for each other to release resources

    Explanation: A database deadlock occurs when two or more transactions are blocked, waiting for each other to release resources, resulting in a standoff.