Question

1. Suppose StudentID is the primary key of one table (e.g., the Students table) and the foreign key of another table (e.g., the Top10DesiredJobs table). If you can’t enforce the referential integrity relationship between these two tables, what might be the cause?

Select one:

a. The values of the primary key column are referenced by the values of the foreign key column.

b. The foreign key contains duplicate data.

c. The foreign key column contains values that do not exist in the primary key column.

d. None of the above.

2. What is the data type of a field if Access automatically assigns a unique AssignmentID number for each new assignment for that field?

Select one:

a. Number

b. Autonumber

c. Short Text

d. AutoText

Answer 1

The answer to this question is as follows:

The answer to the first question is as follows:

When we enforce the referential integrity relationship between these two tables then the foreign key column data should match with the primary key data otherwise the foreign key column contains values that do not exist in the primary key column

so tha answer is option c

The answer to the second question is as follows:

The data type of a filed if Access automatically assigns a unique AssignmentID number for each new assignment for that field is Auto number

so the answer is Auto number(option b)