[Solved] Which of the following in true regarding Referential Integrity?

McqMate

Q.	Which of the following in true regarding Referential Integrity?
A.	every primary-key value must match a primary-key value in an associated table
B.	every primary-key value must match a foreign-key value in an associated table
C.	every foreign-key value must match a foreign-key value in an associated table
D.	every foreign-key value must match a primary-key value in an associated table
Answer» D. every foreign-key value must match a primary-key value in an associated table

1.1k

0

Do you find this helpful?

0

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Which of the following in true regarding Referential Integrity?
Which of the following can be addressed by enforcing a referential integrity constraint?
Which of the following can be used to supplement declarative referential integrity, to enforce complex business rules or to audit changes to data?
Domain constraints, functional dependency and referential integrity are special forms of
In a relational database a referential integrity constraint can be specified with the help of
……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Which of the following is not an integrity constraint?
If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?
Which are the types of integrity rule:
A ____ database state is one in which all data integrity constraints are satisfied.