[Solved] What does the notnull integrity constraint do?

McqMate

Q.	What does the notnull integrity constraint do?
A.	It ensures that at least one tuple is present in the relation
B.	It ensures that at least one foreign key is present in the relation
C.	It ensures that all tuples have a finite value on a specified attribute
D.	It ensures that all tuples have finite attributes on all the relations
Answer» C. It ensures that all tuples have a finite value on a specified attribute

922

0

Do you find this helpful?

10

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

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.
Which of the following is not an integrity constraint?
Which of the following can be addressed by enforcing a referential integrity constraint?
is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
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.
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?
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.
In a relational database a referential integrity constraint can be specified with the help of