Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
188 views
in Structured Query Language by (30.4k points)
closed by

Explain the available database integrity constraints.

1 Answer

+1 vote
by (30.5k points)
selected by
 
Best answer

1. NOT NULL: it species that a column can never have null values, i.e., not empty

2. UNIQUE: it ensures that no two rows have same value in the specified column. 

3. PRIMARY KEY: it declares a column or a set of columns as the primary key of the table. This constraint makes a column NOT NULL and UNIQUE. 

4. DEFAULT: it sets a default value for a column when the user does not enter a value for that column. 

5. Auto_increment: This constraint is used to perform auto_increment the values in a column. That is automatically generate serial numbers. Only one auto_increment column per table is allowed.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...