Interested to Buy Any Domain ? << Click Here >> for more details...
Integrity constraints means..? how many and what are they?
- 4 Answers
- 14569 Views
- AZTEC, I also Faced
- E-Mail Answers
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
What is difference between server and database?
Explain buffer manager?
What is the use of default key?
What is relational database with example?
What is a Transformation?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
How many types of locks are present in a database?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What is a database string?
Which database does facebook use?
A lowest level of security by most RDBMS is
What is the use of graph database?
what is data access layer?
How do you pass parameter in stored procedure?
