Quizific | Customer Table Quiz

A foreign key is:

the primary keyof both relatedtables.

the primary keyof the relatedtable.

a field from anunrelated table.

not a primary key ofeither related table.

You are creating a banking database to track customer loans. The bank will, of course, have many customers, each of whom may take out one or more loans, while each loan may be associated with only one customer (there are no joint accounts). What is the re

One-to-one

One-to-many

Many-to-many

Many-to-one

In a one-to-many relationship between Companies and Employees, which field is found in both tables?

Employee ID

CompanyI D

Employee Last Name

Company Address

Which of the following ensures that records in related tables are consistent with one another? For example, it ensures that you cannot add a record with an invalid foreign key.

The Tools menu,Relationshipwindow

Referentialintegrity

The join line

The one-to-manyrelationship

How would you delete a relationship between tables in the Relationships window?

Double click theRelationship line

Right-click theRelationshipline, then selectDelete from theshortcut menu

Select Undo inthe Relationshipspull-down menu

Click the DeleteRelationships buttonon the toolbar

In a Customers tables, what does a plus sign next to the CustomerID field mean?

That there are several customers associated with that ID

That some of the data is not viewable

That there are records in a related table

That records can be added by clicking on the plus sign

What is required of the fields that join two tables?

They must bothbe numbers

They cannot betext fields

They cannot be Auto Number data types

They must be thesame data type

Assume a one-to-many relationship between the Customers table and the Loans table, with referential integrity in effect. What happens when you attempt to delete a customer ID from the Customer table that still has entries in the Loans table?

Nothing, Access ignores the attempted command.

The customer‟s ID is deleted from the Customers table.

The customer‟sID is deletedfrom theCustomers table, and all the related loans are deleted from the Loans table.

An error message isdisplayed.

Which of the following is true when viewing a main form and its associated subform in the Form Design view?

The subform is not visible.

The subform is displayed in Datasheet view.

The subform is displayed in Form view.

The subform is an object on the form and can be moved or sized like any other object.

Which of the following relationships does not belong in a database based on a professional sports league such as football or basketball?

A one-to-many relationship between teams and players

A one-to-manyrelationship between teams and coaches

A one-to-manyrelationship between coaches and teams

A many-to-many relationship between players and teams