Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity?
- 5 Answers
- 19794 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Is it possible using max on a char column?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
Give the COBOL definition of a VARCHAR field.
What is rebind in db2?
Are views updatable ?
How are write I/Os from the buffer pool executed?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
What is meant by the attachment facility?
What is REORG? When is it used?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
Explain the benefits you can get from mainframe connect?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
COBOL 
