Interested to Buy Any Domain ? << Click Here >> for more details...
Integrity constraints means..? how many and what are they?
- 4 Answers
- 14742 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
how node connect with cpu?
Why do we need distributed database?
What is the difference between specialization and generalization?
What is Object Oriented model?
What happens when shared and exclusive locks are applied on data item?
What is odm database?
if i want to display the name of students such that to which city they belong must have count greaer than two
What is the advantage of varchar2 over char?
What is table scan and index scan?
How does non-cluster index functions?
Why merge statement is used inside the database?
Write a query to retrieve for many to many relationships?
Under which circumstance should you create an index on a table?
how can we view column head in first page but not in remaining pages?
What is ole db source in ssis?
