 Related Questions Latest Answer : Integrity constraint is that which depend upon the parent and child relationship
in which parent column have the primary constraint and child column have the foreign
key constraint.
You cannot delete the any value from column that have foreign key ... Latest Answer : Referential integrity constraint is that which depend upon the parent and child relationship. In this one of the column have the primary key constraint
and one of the column of another table have the foreign key constraint. So you cannot delete ... What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint Answered by Scott on 2005-05-12 10:18:34: Constraints are found under the USER_CONSTRAINTS table. Latest Answer : Correction to some answers aboveUser_Constraints is a view and not a table ... Latest Answer : Alter table modify constraint < constraintname> disable/enableexamplealter table CONTACT_US modify constraint CONTACT_US_UK disable; ... If unique key constraint on DATE column is created, will it validate the rows that are inserted with If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE Integrity constraint is a rule that restricts values to a column in a table. Latest Answer : Integrity constraint restricts values of a column so that only meaningful values as per the business logic of the table be entered into the column.Integrity constraints are of the following types:Not nullUniquePrimary KeyForeign Key (referential integrity)Check ... 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 key of the referenced table. Latest Answer : foreign key constraints is know as referential integrity. which refers to a primary or ( unique ,not null) column ... When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed. Latest Answer : Does not consider parent-child relationship.On deletion of parent record child records are deleated automatically but vise versa is'nt true ... I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain,
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
