[Solved] When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

Q.	When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
A.	Transitive dependency
B.	Insertion anomaly.
C.	Referential integrity constraint.
D.	Normal form
Answer» C. Referential integrity constraint.

736

Do you find this helpful?

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
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
Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identiﬁer, name, and salary attributes. This process is called
State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use on individual key values, allowing other key values to be inserted or deleted from the same leaf.
State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
A integrity constraint requires that the values appearing in speciﬁed attributes of any tuple in the referencing relation also appear in speciﬁed attributes of at least one tuple in the referenced relation.