Integrity constraints means..? how many and what are they?
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
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What are the disadvantages of views in a database?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
What are the advantages of normalizing a database.
What is the purpose of TNS?
What is the Lock Based Protocol used for?
What does specialization in DBMS mean?
How to shrink a database?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
What is relational database with example?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
What is replicaset?
What is the best database software for small businesses?
What is ase database?