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 limits the range of values that can be placed in a column based on a specific condition.

B. It verifies user authentication passwords.

C. It automatically links tables together.

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

Answer: Option A

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

Which schema architecture level describes how the data is physically stored on disk storage media?

A. Conceptual Level

B. External Level

C. Logical Level

D. Internal Level

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Internal (or Physical) level of the three-schema architecture describes the physical storage structure and access paths of the database.

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

Question #2

Which of the following is a logical data model?

A. Both A and C

B. Hierarchical model

C. Physical model

D. Relational model

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Logical data models include relational, hierarchical, and network models. Physical models describe storage details.

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

Question #3

What is the purpose of the SQL 'DEFAULT' constraint?

A. To provide a default value for a column when no value is supplied

B. To enforce uniqueness

C. To define a primary key

D. To set a foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
DEFAULT assigns a default value to a column if an INSERT statement does not specify a value.

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

Explore All Database Management System (DBMS) MCQs