Computer Science and Engineering › Keys in DBMS MCQ › Question #2625
Single Choice Not Set

QA _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

ID: #2625 Keys in DBMS MCQ 21,824 views
Question Info
#2625Q ID
Not SetDifficulty
Keys in DBMS MCQTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A Referential ✔ ✖
  • B Referencing ✔ ✖
  • C Specific ✔ ✖
  • D Primary ✔ ✖
Correct Answer

Explanation

A relation, say r1, may include among its attributes the primary key of another relation, say r2. This attribute is called a foreign key from r1, referencing r2. The relation r1 is also called the referencing relation of the foreign key dependency, and r2 is called the referenced relation of the foreign key.
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .... Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?... Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key?... Which one of the following attribute can be taken as a primary key?... The subset of super key is a candidate key under what condition?... A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.... Which one of the following cannot be taken as a primary key ?... The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.... The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called... The situation where the lock waits only for a specified amount of time for another lock to be released is...