DBMS / RDBMS : Computer Awareness Questions & Answers
Question : Which one is the guideline of Referential integrity in a relationship ?
A.
Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table
B.
Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
C.
Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
D.
Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table
Correct Answer is : Option C.
- Which of the following is not a database model
- The overall description of a database is called______.
- A data dictionary is a repository that manages _____
- What do you mean by one to many relationship between Teacher and Class table?
- What are the different view to present a Table ?