When the foreign key refers to a tuple which does not exists in subjec – McqOptions

MCQOPTIONS

1.	When the foreign key refers to a tuple which does not exists in subjected relation then the constraint violated is
A.	modify integrity
B.	referential integrity
C.	inferential integrity
D.	insert integrity
Answer» C. inferential integrity

Discussion

No Comment Found

Related MCQs

Which transaction contains statements that access more than one node?
What is the mechanism which guarantees that all database servers participating in a distributed transaction either all commit or all roll back the statements in the transaction?
A distributed transaction can be ............. if queries are issued at one or more nodes.
Depending on the situation each node in the Distributed Database system can act as, _________ .
In relational database schemas, the state constraints are also known as
The basic operations that can be performed on relations are
The definition of relation in which values and attributes are ordered in tuple is classified as
A homogeneous distributed database is which of the following?
The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .
Domain constraints, functional dependency and referential integrity are special forms of _________.