[Solved] What is a foreign key?

Q.	What is a foreign key?
A.	A foreign key is a primary key of a relation which is an attribute in another relation
B.	A foreign key is a superkey of a relation which is an attribute in more than one other relations
C.	A foreign key is an attribute of a relation that is a primary key of another relation
D.	A foreign key is the primary key of a relation that does not occur anywhere else in the schema
Answer» C. A foreign key is an attribute of a relation that is a primary key of another relation

View all MCQs in: DataBase Management System (DBMS)

Discussion

Related Questions

State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.
A primary key is combined with a foreign key creates
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
A primary key when combined with a foreign key create
A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency
In the above DDL command the foreign key entries are got by using the keyword
In the section relation which of the following is used as a foreign key?