Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
What is Data Integrity?
Nice?
Vote!
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
siva
(
10,720
points)
–
edited
1 year
ago
by
R
sql-server-interview-question
database
dbms
1 Answer
Nice?
Vote!
Best answer
The following categories of the data integrity exist with each RDBMS:
Entity Integrity :
--------------------
There are no duplicate rows in a table.
Domain Integrity :
------------------------
Enforces valid entries for a given column by restricting the type, the format, or the range of values.
Referential integrity :
----------------------------
Rows cannot be deleted, which are used by other records.
User-Defined Integrity :
-------------------------------
Enforces some specific business rules that do not fall into entity, domain, or referential integrity.
answered
1 year
ago
by
R
(
19,530
points)
Related questions
Nice?
Vote!
Add
Ans!
What is difference between DBMS and RDBMS?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
Pandi
(
540
points)
sql-server-interview-question
database
rdbms
dbms
+1
vote
1
answer
What is extension and intension?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
database
dbms
rdbms
+1
vote
1
answer
What is SQL Constraints?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
siva
(
10,720
points)
sql-server-interview-question
database
dbms
constraints
+1
vote
2
answers
What is NULL value?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
siva
(
10,720
points)
sql-server-interview-question
database
dbms
Nice?
Vote!
1
answer
What is column?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
siva
(
10,720
points)
sql-server-interview-question
database
dbms
table
t-sql