Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

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

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