What is a database lock? MCQ with Answer and Explanation

Question

Share Report Error

What is a database lock?

A. A type of index

B. A user account

C. A mechanism to prevent simultaneous access to the same data causing inconsistency

D. A backup file

Answer: Option C

Solution (By JKSSB Mock Tests)

Locking is a concurrency control mechanism that ensures data integrity during simultaneous transactions.

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

Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement?

A. Static Subquery

B. Independent Subquery

C. Correlated Subquery

D. Scalar Subquery

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.

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

Question #2

Share Report

What does a database constraint called a 'CHECK' constraint do?

A. It automatically links tables together.

B. It verifies user authentication passwords.

C. It checks if the database server is running safely.

D. It limits the range of values that can be placed in a column based on a specific condition.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A CHECK constraint enforces domain integrity by limiting the values accepted by a column to only those that satisfy a specified Boolean predicate.

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