Every primary-key value must match a primary-key value in an associated table
Every primary-key value must match a foreign-key value in an associated table
Every foreign-key value must match a primary-key value in an associated table
Every foreign-key value must match a foreign-key value in an associated table
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following in true regarding Referential Integrity?
Discover Related MCQs
Q. How many types of keys in Database Design?
Q. The minimal set of super key is called
Q. Foreign key is the one in which the ________ of one relation is referenced in another relation.
Q. Domain constraints, functional dependency and referential integrity are special forms of _________.
Q. Which one of the following uniquely identifies the elements in the relation?
Q. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
Q. Which one of the following attribute can be taken as a primary key ?
Q. Which one of the following cannot be taken as a primary key ?
Q. A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
Q. 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
Q. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .
Q. A _________ 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.
Q. Row is synonymous with the term:
Q. The primary key is selected from the:
Q. Which of the following is a group of one or more attributes that uniquely identifies a row?
Q. A relation is considered a:
Q. In the relational model, relationships between relations or tables are created by using:
Q. Table is synonymous with the term:
Q. Which of the following is not a restriction for a table to be a relation?
Q. A key:
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
Learn about the systematic approach to developing software with our Software...
Master the building blocks of the web with our Web Technologies MCQs. From HTML and...
Dive deep into the core of computers with our Operating System MCQs. Learn about...
Digital Image Processing (DIP)
Delve into the techniques of enhancing digital images with our Digital Image...
Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...
Level up your coding skills with our Java Programming MCQs. From object-oriented...