1. Referential integrity means Select one: a. Do not enter a value in the foreig

Question

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

Explanation / Answer

1) Option a is correct explanation is generally the child table will have foreign key and it will refer to parent table primary key field so when you are entering the values into the child table make sure that the values are already present in the parent table other wise referential violation will be possible.

2)option b it also because of same reason that is if we don't update then referential violation will be possible.

4) in one-to-many relationship the one side is parent and many side is child

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.