Question

 CHECK Constraint

07 Aug 2026
Answer :
Word Count : 1316
The CHECK constraint is an important integrity constraint in a Database Management System (DBMS) that is used to restrict the values that can be stored in a table. It ensures that data entered into a database satisfies a specified condition or rule. A database may contain large amounts of information, and without appropriate restrictions, users may accidentally enter invalid, unreasonable, or inconsistent values. The CHECK constraint helps maintain data accuracy, consistency, and reliability by allowing only those values that satisfy a predefined condition. In a relational database, a table consists of rows and columns. Each column may have certain requirements regarding the type and range of data that it can contain. While a data type specifies the general form of data, such as INTEGER, VARCHAR, DATE, or DECIMAL, it does not always specify whether a particular value is logically acceptable. For example, an INTEGER column used for storing the age of employees may accept negative numbers even though a negative age is not meaningful. Similarly, a salary column may accept a value of zero or a negative amount unless an appropriate restriction is applied. The CHECK constraint can be used to prevent such invalid values. The basic syntax for defining a CHECK constraint is: ```sql CREATE TABLE table_name ( column1 datatype, column2 datatype CHECK (condition), column3 datatype ); ``` A CHECK constraint can be applied directly to an individual column or can be defined at the table level. A column-level CHECK constraint generally applies to the value entered in that particular column. For example: ```sql CREATE TABLE Employee ( Employee_ID INT, Name VARCHAR(50), Age INT CHECK (Age >= 18), Salary DECIMAL(10,2) CHECK (Salary > 0) ); ``` In this example, the Age column can contain only values that are 18 or greater, while the Salary column must contain a value greater than zero. If an attempt is made to insert an employee whose age is 15 or whose salary is negative, the DBMS will reject the operation because the
______ _____ ______ ____ _____ ______ _______ _______.
__________ _________ ________ ____ __________ _____ ___ _________.
_________ ________ ____ _____ _______ ________ _________ ____.
___ ___ ______ ________ ____ __________ ______ _____ ___ ______.
__________ _______ ____ ____ ______.
__________ ___ ______ ______ __________ ______.
_________ _______ _____ _________ ___.
_____ _____ __________ ______ __________ ______ _________ _____ __________ ________ ______.
___ __________ _________ _______ _________ ___ ______.
____ ______ ________ _______ _________ ________ ___.
________ _____ _______ ______ _________ _____ _______ ___ _____ ________ __________.
_____ _______ _______ __________ ___.
___ _______ ____ __________ __________.
_______ _____ _________ ___ ________ __________ _____ _________ _______ ____ ____.
_________ _______ _________ _________ _______ _________ __________ _______.
_____ ____ ______ ____ __________ ________.
______ __________ __________ _________ ____ ____ __________ ________ _________.
_________ __________ ________ ______ _______ ______ ___ _____ ________ ____ ____.
______ __________ _____ ___ ____ _______.
____ ______ ___ ______ ________ ________ _________ __________ ________ ________ ___.
____ _______ ________ __________ _____ _________ ____ ____.
__________ _____ __________ __________ _________ ____ _____ ________ ____ __________ _________ _________.
______ _________ _______ _______ ___ _________.
______ _______ ____ __________ _______.
____ _______ ________ _____ ____ _________ ________.
_______ ________ _________ ________ _______ _____ ___ _______ ______.
____ ______ ___ _____ ________ __________ ______ __________ ________ ______ _________.
_____ ___ __________ ______ __________ _________ ___ ______ ____ ________.
_____ _____ ______ ____ ___ ____ ______ __________ _______.
_____ ______ __________ __________ ________ __________.
____ _____ _______ _________ ______ _________ _____.
______ ______ ____ _____ _______ ____.
_________ ____ ____ ____ _____ ______ __________ _________.
__________ ______ _____ _______ __________ ________ _________ _____ ____ __________.
_______ _________ __________ _________ _______ ________ ___ _____ _____.
_____ _________ _________ _____ ____ _________ ____ __________ ____ ________ ____ _____.
________ ________ _______ _____ ____ ________ _________.
__________ ____ ________ ___ ___ _____ _________ ____ _________.
_____ ___ ________ _______ ___ __________ _________ ________ ______ _____ ____ _____.
____ ___ ___ _____ _____ __________ ____ ______ _______ _____ ___ _____.
___ ______ ___ ____ ____ _________ __________ _________.
___ _____ __________ _________ ____ __________ ____ ___.
____ _____ ____ _______ ______ ___ ______.
_________ _____ ______ _____ ___ _______ _______ ____ __________ ___.
_____ _________ ____ __________ ______ _____ _____ ______ ___ _____.
_____ ____ _________ __________ ________ ____ _________ _____ __________ ________ ______.
____ ____ ____ _____ ___ ________ ________.
________ _________ ________ _______ _________ ___ _______.
____ _________ __________ ______ ________ _________ ___ ________.
______ _______ _______ ___ _____ _____ _________ _________ _______ ______ _______.
___ _______ _______ _______ ___ _____ ______ ________ _______.
__________ ____ _________ _________ ____ ____ ______ _________ ____.
___ ____ ___ ______ ___ _____ __________ ________ _________ _____ ________.
__________ _______ ______ ____ _______ ___ ________ ___ ________ _____.
___ ___ __________ _____ _____ __________ ____ ______ _____ ___.
__________ ______ _____ ___ _______ _________ ___ __________.
_________ _________ _____ _________ _________ __________ _______ ______ ________ _______ _________ _________.
___ ________ ________ ___ ______ ______ _________ ______ ______ ____ ___ _________.
_________ ____ ______ ____ ________ _____ ______ ______ _______ ___.
__________ ________ ______ _____ __________ ______ _________ _____ ________ ________.
___ ____ ____ ____ ____ __________ _____.
_________ ___ ______ ______ __________ _____ ____ ____ ________ ______ ___ _______.
______ ____ ____ _______ ____ ____ ______.
___ ___ __________ __________ __________ ______ ________ __________ _____ ____ _________ __________.
___ _____ ________ __________ _____ _____.
_______ ______ ________ ___ _______ ______ ___ __________ __________ __________ _________.
_____ __________ ____ _______ __________.
____ ____ ________ _____ _____ ________ __________ ______ _______.
_____ ____ ______ ________ ___ _______ __________ ___ _____.
_________ _________ __________ ______ _____ ________ ____ _____ ____.
___ _______ ______ ___ ______ ______ ___ _____ __________.
________ _________ ______ _________ _____ _______.
_______ _______ _________ _____ __________ __________ ____ _____ ________.
________ ___ ___ _______ ________ ___ _______ ___ ___ _______ __________.
____ _____ ___ ________ ______ _________ ____ ________ ____ _________ ________.
______ _________ _________ ________ _______ _______ ____ ____ _____ _____ ___ _________.
_________ _______ __________ _______ _____ ______ ________ ________ _____ ____.
____ ______ _______ _________ _________ ___ __________ _________.
___ _________ ______ ____ ___ __________ ________ _____ _____.
______ ____ _________ _________ ______.
_____ ________ _______ _______ _________ ________.
__________ ___ _______ _______ ____ _______ ________ _____ ______ ___ _____.
_________ _________ ________ ______ _______.
______ ________ __________ ____ _______ ____ _____ ____ __________ ___ ___ ___.
___ _______ _________ ____ ________ ________ ________ ______ ______ ____.
______ _______ ____ _________ _________ _________ ___ ______ ________.
______ _______ _________ ___ ________.
_____ __________ ___ ________ _________ ________ ________ __________ _____ __________ ____.
_______ ____ ____ __________ __________.
_____ ___ __________ ______ _____ ____ ____ ______.
________ ______ _____ ________ _____ ___ _________ ________ ____ ______ _________.
___ ____ _________ ___ _________ ___ ___ _______ ____ ________.
____ _______ _________ __________ ________ _____ ________ ________ __________ __________ __________.
__________ ______ ___ __________ ___ ___ __________ _____ ___ __________ ___.
_________ ___ _____ _____ _____.
_________ ____ _______ ____ ___ __________ __________ ____ ________ _______.
____ _________ ___ _________ __________ __________ ___ _____ _________ ________.
_____ _______ ________ ___ ______ ________ ____.
______ _______ ____ ______ _____ _________ ______ __________ _____ ____.
________ ____ _____ ___ _____ __________ __________ ___ _______.
_____ _______ _________ ____ _________ __________ _____ _____ _________ _____.
____ _____ __________ _____ ___ ______ ________.
_____ ___ __________ __________ ________ __________.
____ _____ ____ _____ ________ ___ ___ ________ ________ ___ _______.
___ _________ _______ ________ ______ _________ ________ __________ _________ __________ __________.
___ _______ ________ _____ _________.
_________ ___ _______ ___ ____.
________ _________ _____ __________ ____ _____ _______ _______ ___ _______ _______.
___ ___ ___ ___ _________ ____ _________ _________.
___ ______ ___ ______ _______ __________ __________ ______.
_________ __________ ________ _______ ___ ________ _________ _____ ______.
_________ ____ _______ ________ ____.
___ ____ ________ ___ _____ ___ _______ ______ ____ _____.
________ ______ _____ _________ ________ ______ ___.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MCS 23 2026 2027 -  CHECK Constraint | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→