1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What are foreign keys?

Question Posted / guest


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

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

What is explain plan in db2?

0 Answers  

What is db2 optimizer?

0 Answers  

Explain various types of locks in db2?

0 Answers  

What is cursor stability?

1 Answers  




explain about index with examples

2 Answers   Syntel,

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

What is database alias db2?

0 Answers  

what is the Foreign key? explain?

2 Answers  

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,

What does the RUNSTATS Utility do?

4 Answers  

For more DB2 Interview Questions Click Here
Categories