What are foreign keys ?
These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled? 05.12.08
Get keys, Create keys and Find keys gets created automaticallyThe Create method is created alongwith the other Standard methods for the CI...Which of the following are TRUE when a Component Interface (CI) is created on component that has “Add” action enabled ? 12.08.08
Get keys, Create keys and Find keys gets created automaticallyThe Create method is created alongwith the other Standard methods for the CI...What is a foreign key ? 14.07.08
A foreign key is the key defined in one table to reference the primary key of a reference table. This foreign key must have the same structure as the reference...What is the difference between Truncate and Delete interms of Referential Integrity? 14.05.08
DELETE removes one or more records in a table, checking referential Constraints (to see if there are dependent child records) and firing any DELETE triggers....Is there any advantage to denormalizing DB2 tables ? 28.03.08
Denormalizing DB2 tables reduces the need for processing intensive relational joins and reduces the number of foreign keys....What are matchcodes? 05.04.07
It is similar to table index that gives list of possible values for either primary keys or non-primary keys....What are the check tables and value tables? 26.03.07
Check Table: The ABAP Dictionary allows you to define relationships between tables using foreign keys . A dependent table is called a foreign key table, and the...What are fact tables? 22.06.06
A fact table is a table that contains summarized numerical and historical data (facts) and a multipart index composed of foreign keys from the primary keys of r...Which columns go to the fact table and which columns go the dimension table? 17.03.06
The Primary Key columns of the Tables(Entities) go to the Dimension Tables as Foreign Keys. The Primary Key columns of the Dimension Tables go to the Fact Tabl...What is foreign key relationship? 12.03.06
A relationship which can be defined between tables and must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data...