What is referential integrity?

Answers were Sorted based on User's Feedback



What is referential integrity?..

Answer / sadiq afroze

Referential integrity refers to the consistency that must be
maintained between primary and foreign keys, i.e. every
foreign key value must have a corresponding primary key value

Is This Answer Correct ?    22 Yes 5 No

What is referential integrity?..

Answer / renu gupta

Referential integrity refers to the consistency that must
be maintained between primary and foreign keys.

1.An insert into primary key table cannot violate
referential integrity and no checking is required
2.A deletion of foreign key value can not violate
referential integrity and no checking is required
3.Changes in primary key is allowed only when those values
are not in foreign key.
4.Insert and updates in foreign key is allowed only when it
has a matching value in primary key
5. If RESTRICT is specified on foreign key definition,
deletion of primary key is not allowed
6. If CASCADE is specified, both primary and foerign keys
values can be deleted together only
7. If SET NULL is specified, then the foreign key value is
set null , provided nulls are allowed in the foreign key
column

Is This Answer Correct ?    12 Yes 4 No

What is referential integrity?..

Answer / raghavendra k

For every Foriegn Key value in child table, there must be
same value is present in primary key column of parent table.

Is This Answer Correct ?    6 Yes 3 No

What is referential integrity?..

Answer / pranab kumar mohanty

The relation of the primary key of a base table with
foreign key of the reference table is known as referential
integriety.

Is This Answer Correct ?    5 Yes 2 No

What is referential integrity?..

Answer / guest

It is used relate more than table using RDBMS.For example
if you two table TAB1,TAB2.TAB1 which has column empno with
value ,TAB2 which has same value as previous mentioned TAB1
value.

Row in one table that are related Row in another table .

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More DB2 Interview Questions

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  


What is a root page?

1 Answers  


What is explain plan in db2?

0 Answers  


How can you find out the # of rows updated after an update statement?

0 Answers  


suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,






What is image copy in db2?

0 Answers  


How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,


How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,


What is index in db2?

1 Answers  


What is the function of the Data Manager?

2 Answers  


There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,


How do you pull up a query which was previously saved in qmf?

0 Answers  


Categories