What is the self-referencing constraint ?
The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.
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
What is entity referencing? 22.11.08
Referencing the entity by name causes it to be inserted into the document in place of the entity reference. To create an entity reference, the entity name is su...Can you use someone else’s Style Sheet without permission? 29.08.08
This is a somewhat fuzzy issue. As with HTML tags, style sheet information is given using a special language syntax. Use of the language is not copyrighted, and...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 is it better to use an integrity constraint to validate data in a table than to use a stored procedure? 14.05.08
Because an integrity constraint is automatically checked while data is inserted into a table. A stored has to be specifically invoked....A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? 06.08.06
Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint....What is Domain-Key Normal Form? 30.06.06
A relation is said to be in DKNF if all constraints and dependencies that should hold on the the constraint can be enforced by simply enforcing the domain const...How you will set the datarelation between two columns? 14.03.06
ADO.NET provides DataRelation object to set relation between two columns.It helps to enforce the following constraints,a unique constraint, which guarantees t...What is an Integrity Constraint ? 12.03.06
Integrity constraint is a rule that restricts values to a column in a table....What is security constraint 11.03.06
A declarative way to annotate the intended protection of Web content. A security constraint consists of a Web resource collection, an authorization constraint,...What is Functional Dependency? 08.03.06
A Functional dependency is denoted by XÂ Â Â Â Y between two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple that...