Answer Posted / 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 View All Answers
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How does cobol compile db2 program?
define clustering index.
How do I add a column to a table in db2?
Mention the various locks that are available in db2.
what are bind concepts in db2 cobol?
What is ibm db2 database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
List down the types of triggers in the db2 database?
What is a plan and package in db2?
What is db2 optimizer?
What is dclgen in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is copy pending status in db2?