Give two examples of referential integrity constraints?
A primary key and a foreign key.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Describe referential integrity ? 26.07.08
Referential integrity refers to a feature in DB2 that is used to ensure consistency of the data in the database....How will you activate/deactivate integrity constraints? 17.05.08
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT....Why are the integrity constraints preferred to database triggers? 14.05.08
Because it is easier to define an integrity constraint than a database trigger....What is the difference between Truncate and Delete interms of Referential Integrity? 14.05.08
DELETE removes one or more records in a table, checking referential Constraints (to see if there are dependent child records) and firing any DELETE triggers....When can an insert of a new primary key value threaten referential integrity ? 01.04.08
Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary key values in their related tables...What is a mutating and constraining table? 22.08.06
"Mutating" means "changing". A mutating table is a table that is currently being modified by an update, delete, or insert statement. When a trigger tries to ref...What are triggers? How to invoke a trigger on demand? 06.08.06
Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table. Triggers ca...Define the “integrity rules” . 30.06.06
There are two Integrity rules. Ø Entity Integrity: States that “Primary key cannot have NULL value” Ø Referential Integrity: States that “Foreign Key...What is Referential Integrity ? 12.03.06
Maintaining data integrity through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key or unique...How is the data structure of System R different from the relational structure? 08.03.06
Unlike Relational systems in System R Domains are not supported Enforcement of candidate key uniqueness is optional Enforcement of entity integrity is option...