What does a database constraint called a 'CHECK' constraint do? MCQ with Answer and Explanation

Question

Share Report Error

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

A. It automatically links tables together.

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

C. It verifies user authentication passwords.

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

Answer: Option D

Solution (By JKSSB Mock Tests)

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)

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

In the context of databases, what is a 'tuple'?

A. A table itself

B. A column of a table

C. A key constraint

D. A row of a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In relational databases, a tuple is a single row or record of a table.

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

Question #2

Which type of lock prevents other concurrent transactions from obtaining any form of lock on the same row, securing exclusive read and write access?

A. Shared Lock

B. Implicit Lock

C. Static Lock

D. Exclusive Lock

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
An Exclusive Lock (X-lock) blocks all other locks, ensuring that only the transaction holding the lock can modify or read the protected resource.

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

Question #3

What is the purpose of the SAVEPOINT statement?

A. To create a point within a transaction to which you can later roll back

B. To permanently save changes

C. To release locks

D. To start a new transaction

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
SAVEPOINT creates a named point within a transaction, allowing partial rollback to that point without affecting the entire transaction.

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

Explore All Database Management System (DBMS) MCQs