What is a deadlock in a database? MCQ with Answer and Explanation

Question

Share Report Error

What is a deadlock in a database?

A. A situation where two or more transactions are waiting indefinitely for each other to release locks

B. A query error

C. A system crash

D. A type of backup

Answer: Option A

Solution (By JKSSB Mock Tests)

Deadlock occurs when each transaction holds a lock that the other needs, resulting in a circular .

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

How many fundamental rules did E.F. Codd define to determine whether a database system qualifies as a true relational database management system?

A. 12 rules

B. 14 rules

C. 8 rules

D. 10 rules

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
E.F. Codd formulated 12 rules (numbered 0 to 11, often called Codd's 12 Rules) to evaluate relational database management systems.

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

Question #2

Share Report

What is a stored procedure?

A. A set of precompiled SQL statements that can be executed as a single unit

B. A trigger

C. An index

D. A view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A stored procedure is a named collection of SQL statements and logic stored in the database, which can be invoked by applications.

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

Question #3

Share Report

Which of the following is a valid SQL statement to add a new column to a table?

A. ADD COLUMN TO table_name column_name datatype;

B. ALTER TABLE table_name ADD COLUMN column_name datatype;

C. Both A and C

D. ALTER TABLE table_name ADD column_name datatype;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.

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

Explore All Database Management System (DBMS) MCQs