Which of the following is a method to avoid deadlock? MCQ with Answer and Explanation

Question Report Error

Which of the following is a method to avoid deadlock?

A. Lock ordering

B. Using a timeout

C. All of the above

D. Deadlock detection and resolution

Answer: Option C

Solution (By JKExamLibrary)

Strategies to handle deadlocks include timeout, lock ordering, and detection with rollback.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?

A. Diamond

B. Triangle

C. Ellipse

D. Rectangle

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.

This question belongs to: Computer Database Management System (DBMS)

Question #2 Report Error

Which of the following is a TCL (Transaction Control Language) command?

A. CREATE

B. SELECT

C. SAVEPOINT

D. DROP

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Transaction Control Language includes COMMIT, ROLLBACK, and SAVEPOINT.

This question belongs to: Computer Database Management System (DBMS)

Question #3 Report Error

What is an attribute called when it can hold more than one value for a single entity instance, such as multiple phone numbers for a person?

A. Composite Attribute

B. Derived Attribute

C. Multi-valued Attribute

D. Complex Attribute

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
A Multi-valued Attribute is an attribute that can store multiple distinct values for a single entity instance (e.g., skill_set, phone_numbers).

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs