Integrity constraints means..? how many and what are they?
- 4 Answers
- 13356 Views
- AZTEC, I also Faced
- E-Mail Answers
Answer Posted / swetcha
Integrity constraints provide a way of ensuring that
changes made to the database by authorized users do not
result in a loss of data consistency.
An integrity constraint can be any arbitrary predicate
applied to the database.
They may be costly to evaluate, so we will only consider
integrity constraints that can be tested with minimal
overhead.
Types of integrity constraints
(1) Non-null
(2) Key
(3) Referential integrity
(4) Attribute-based
(5) Tuple-based
(6) General assertions
plzz let me know if it's wrong
| Is This Answer Correct ? | 18 Yes | 9 No |
Post New Answer View All Answers
What is the role of tester in discovery(in Checklist)?
how can we view column head in first page but not in remaining pages?
Which database is best to store images?
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 Transformation?
What is a database lookup?
How to do performance tunning a database in DB2 V8.2 UDB in linux
Differentiate between extension & intension?
Explain buffer manager?
Differentiate between unique key and foreign key?
What is the candidate key used for?
Explain entity type?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is a Database?
how node connect with cpu?
