Integrity constraints means..? how many and what are they?
Answer Posted / firoz basha
Integrity constraint:- An IC is one which does not allow
invalid data entry into the database.
there are 3 types of Integrity constraints:
1. Entity Integrity COnstraint
primary key
unique key
Primary key does not allow null values and duplicate
values
unique key does not allow duplicate values.
unique key allows any number of null values (in case
of oracle)
unikey key allows only one null value. i.e, single null
value ( in the case of sql server 2000)
2. Domain Integrity Constraint
not null constraint
check constraint
rule constraint (in case of SQL SERVER 2000)
rule is an alternate to check constraint
3. Referential Integrity constraint
foreign key constraint
Is This Answer Correct ? | 34 Yes | 1 No |
Post New Answer View All Answers
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
Can we use redis as database?
How do I setup a database connection?
aht is the difference b/w network & hierarchial & relational dbms????
What are the most common databases?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
How does non-cluster index functions?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
What is a super key?
What is table scan and index scan?
What does new grouping sets enables you to do?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
Why merge statement is used inside the database?
What do you mean by foreign key and primary key?
What is database schema name?