1. Referential integrity means

Select one:

a. 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

b. Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table

c. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table

d. All of above

2.

cascade update option (in the context of referential integrity)

Select one:

a. means do not change the value in the primary key field if that record has related records in another table

b. means change all the related records in child tables if the record in parent table is changed

c. Both of above

d. None of above

3.

The inner join is typically the most common form of join used in application queries (true/false)?

Select one:

True

False

4.

In one-to-many relationship the table in one side is called _______ and on many side is called _______

Select one:

a. Child , Parent

b. Parent , Child

c. Brother , Sister

d. Father , Son