Database Management Systems (DBMS)
Which of the following best describes Transaction deadlock?
Difficulty: Hard
- A. A database structure that improves the speed of data retrieval operations on a table.
- B. A diagram that visually represents entities and their relationships within a database.
- C. A virtual table based on the result of a stored SQL query.
- D. A situation in which two transactions are each waiting for the other to release a lock, preventing progress. ✓
Correct answer
D. A situation in which two transactions are each waiting for the other to release a lock, preventing progress.
Correct answer
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- What does Database view refer to?
- Which term refers to a virtual table based on the result of a stored SQL query?
- Select the accurate description of Database trigger.
- The following statement describes a specific concept. What is it called? a stored procedure that automatically...
- What is Denormalization primarily used for?
- Which concept is defined as follows: the process of intentionally introducing redundancy into a database to im...