What are foreign keys?



What are foreign keys?..

Answer / vamsikrishnamraju

A foreign key is a referential constraint between two
tables.The foreign key identifies a column or a set of
columns in one (referencing) table that refers to a column
or set of columns in another (referenced) table. The
columns in the referenced table must form a primary key or
unique key.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is bind in db2?

0 Answers  


What is innodb buffer pool?

0 Answers  


what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,


What is a DB2 plan?

8 Answers  


Mention the various locks that are available in db2.

0 Answers  






What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  


Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  


What is a clustering index?

2 Answers  


How to find the number of rows in a db2 table?

0 Answers  


What is meant by AUTO COMMIT?

3 Answers  


How do I start db2 in windows?

0 Answers  


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


Categories