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

How many types of locks are present in a database?

1134

---

aht is the difference b/w network & hierarchial & relational dbms????

2216

---

Data structure used to implements a menu:

1164

---

What is sharded database?

956

---

what is the role of auditor in auditing data oriented applications?

2392

---

What is a database lookup?

1095

---

can u combine pipeline parallelism and partition parallalism? how and whan?

2335

---

Explain entity type?

995

---

What does specialization in DBMS mean?

1158

---

What is the advantage of varchar2 over char?

1270

---

Explain database partitioning.

1077

---

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

2044

---

What is database server and how it works?

1044

---

What are the various ways to execute a query in teradata?

2614

---

What is the difference between database and server?

1023

---