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

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

Answer / sriram s

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

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 !

What are the two categories of Client-Server application development?

1 Answers  

---

what is transaction state, buffer management, shadow paging

0 Answers  

---

What advantages does DBMS have over traditional file systems?

0 Answers   ABB, Infogain,

---

How many types of normalization? What is the use of it?

0 Answers   Accenture,

---

Which database does facebook use?

0 Answers  

---

---

How to produce such kind of file?

0 Answers   Tech Mahindra,

---

Differentiate between extension & intension?

0 Answers  

---

Does facebook use graph database?

0 Answers  

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

0 Answers   3i Infotech,

---

What is sqlcode -923 ?

1 Answers  

---

What does new grouping sets enables you to do?

0 Answers   ADITI,

---

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

0 Answers   Datamatics,

---