Integrity constraints means..? how many and what are they?

Question Posted / guest

4 Answers
14740 Views
AZTEC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Integrity constraints means..? how many and what are they?..

Answer / 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

Integrity constraints means..? how many and what are they?..

Answer / 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

Integrity constraints means..? how many and what are they?..

Answer / sriram s

Domain integrity enforces valid entries for a given column
by restricting the type , the format or the range of
possible values

Is This Answer Correct ?

6 Yes

0 No

Integrity constraints means..? how many and what are they?..

Answer / xmanenter

Domain Integrity Constraint
//not null constraint this is not come
check constraint
//rule constraint (in case of SQL SERVER 2000)
//rule is an alternate to check constraint
only check because it is used as whole domain while all are
in row or tuple !

Is This Answer Correct ?

4 Yes

0 No

Post New Answer

More Databases AllOther Interview Questions

How is image stored in database?

0 Answers

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

0 Answers

What is a database lookup?

0 Answers

Should I store images in database?

0 Answers

What advantages does DBMS have over traditional file systems?

0 Answers ABB, Infogain,

how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

0 Answers

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

0 Answers

What is replicaset?

0 Answers

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

0 Answers

Differentiate between delete and truncate table?

0 Answers

What are the validations performed on the source data? If there are junk data available in the source data, how to eliminate it?

0 Answers BDI Systems, Google,

What are different types of blocks used in stored procedure?

0 Answers C DAC, CDAC,

For more Databases AllOther Interview Questions Click Here