Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
What are the two general categories of database management systems?
a. | file management system and relational database management system | b. | server based system
and Web based system | c. | relational database management system and
binary system | d. | PC based system and mainframe based system |
|
|
|
2.
|
File management systems are sometimes referred to as
a. | SQL databases. | b. | flat file databases. | c. | indexing
systems. | d. | relational databases. |
|
|
|
3.
|
Which of the following features is found in a relation database management
system but not in a file management system?
a. | indexing | b. | sequential processing | c. | the ability to join
tables | d. | All of the above |
|
|
|
4.
|
A relational database management system eliminates the need for
a. | sequential processing. | b. | multiple tables. | c. | indexes. | d. | data
redundancy. |
|
|
|
5.
|
Chapter 2 emphasizes that in planning your database and its related tables, it
is important to consider
a. | what each table is “about.” | b. | the number of fields
in each table. | c. | how many records each table will hold. | d. | the overall size of each
table. |
|
|
|
6.
|
The ability to relate, or ____ tables is part of what makes Access a relational
database system.
a. | join | b. | merge | c. | append | d. | parse |
|
|
|
7.
|
Before you create a relationship between tables, you need to
a. | backup your database. | b. | define a primary key in a
table. | c. | enter fields descriptions for each field in each table. | d. | sort each table by
the first field in the table. |
|
|
|
8.
|
A primary key is made up of
a. | one or more fields. | b. | only one field. | c. | at least three
fields. | d. | at least two fields. |
|
|
|
9.
|
A primary key field ____ contain the same value for different records.
a. | cannot | b. | can | c. | must | d. | should |
|
|
|
10.
|
For primary keys fields, Access enforces entity integrity, meaning that
a. | it expects a value in the primary key field(s) for each record in the
table. | b. | the values in the primary key field(s) must be numeric and
sequential. | c. | the primary key fields(s) must be assigned the AutoNumber data
type. | d. | only letters and numbers can be entered in the primary key
field(s). |
|
|
|
11.
|
What happens if you try to leave a primary key field blank?
a. | Access will automatically fill the field with a random number. | b. | Access will not let
you close the table until a value is filled in. | c. | Access will automatically fill the field using
a sequential pattern based on previous entries. | d. | Nothing; primary key fields may be left
blank. |
|
|
|
12.
|
In which group will you find the Primary Key button?
a. | Show/Hide group in the Table Tools Design tab | b. | Records group in the
Home tab | c. | Other group in the Create tab | d. | Tools group in the Table Tools Design
tab |
|
|
|
13.
|
When a relationship is established between two tables, the primary key in one
table is joined to the ____ key in the other table.
a. | foreign | b. | client | c. | subordinate | d. | secondary |
|
|
|
14.
|
Values in a foreign key field ____ be duplicated across records.
a. | cannot | b. | must | c. | can, but should
not | d. | can |
|
|
|
15.
|
When you perform a join, you are
a. | connecting one database to another. | b. | relating one table to
another. | c. | appending date from one table to another. | d. | importing data from
another application into Access. |
|
|
|
16.
|
How does joining tables help ensure data integrity?
a. | by automatically checking for misspelled words | b. | by ensuring
sequential values in the primary key field | c. | by forcing a record to be in the primary table
(e.g., Customers) before it can be entered into a related table (e.g.,
Orders) | d. | All of the above |
|
|
|
17.
|
In a one-to-many relationship, the table containing the “one” is
referred to as the ____ table.
a. | key | b. | secondary | c. | related | d. | primary |
|
|
|
18.
|
In a one-to-many relationship, which table would contain the foreign key for the
relationship?
a. | both primary and related tables | b. | primary table | c. | neither primary nor
related tables | d. | related table |
|
|
|
19.
|
____ integrity rules ensure that a record added to a related table has a
matching record in the primary table.
a. | Personal | b. | Entity | c. | Experiential | d. | Referential |
|
|
|
20.
|
When are referential integrity rules enforced?
a. | when data is updated in related tables | b. | when the database is closed | c. | when a primary table
is opened | d. | when the database is opened |
|
|
|
21.
|
To create a one-to-many relationship between two tables, open the database
containing the tables and then click the Relationship button in the
a. | Database Tools group in the Database Tools tab. | b. | Other group in the
Create tab. | c. | Show/Hide group in the Database Tools tab. | d. | Records group in the
Home tab. |
|
|
|
22.
|
Before you have established any relationships among your tables, what happens
after you click the Relationships button?
a. | The Show Table dialog box is displayed. | b. | You must drag the
tables you want to work with from the Navigation pane to the Relationships
window. | c. | All tables in the database are placed in the Relationships
window. | d. | Access automatically assigns a primary key to any tables in the database that do not
already have one. |
|
|
|
23.
|
In defining a one-to-many relationship between two tables, what is the next step
after having placed the two tables in the Relationships window?
a. | Drag the common field from the primary table to the related
table. | b. | Right-click the foreign key field in the related table. | c. | Right-click the
primary key field in the primary table. | d. | Drag the primary table on top of the related
table. |
|
|
|
24.
|
What is displayed in the three-row grid in the middle of the Edit Relationships
window?
a. | the common fields to be used to join the tables | b. | the names of the
tables to be joined | c. | the type of join to be
established | d. | the actions that will be enforced as a result of the
join |
|
|
|
25.
|
How are joins represented visually in the Relationships window?
a. | The common fields are displayed in bold italic font. | b. | The joined tables
are merged and display as if they are one table. | c. | The joined tables are placed next to one
another with the common fields aligned. | d. | A black line connects the common fields in the
tables. |
|
|
|
26.
|
In the Relationships window, what symbol or character signifies the
“many” side of a one-to-many relationship?
a. | the infinity symbol (¥) | b. | the number one (1) | c. | an exclamation point
(!) | d. | the number one thousand (1,000) |
|
|
|
27.
|
In the Edit Relationships dialog box, referential integrity can be set if the
field from the primary table is a primary key and the related fields have the same
a. | field name. | b. | indexing applied. | c. | data
type. | d. | All of the above |
|
|
|
28.
|
If in the Edit Relationships dialog box you choose only Enforce Referential
Integrity and the related table contains a record, you will not be able to
a. | make edits to any field in the related table. | b. | change or delete a
primary key value in the related table. | c. | change or delete a primary key value in the
primary table. | d. | All of the above |
|
|
|
29.
|
Choosing Cascade Update Related Fields and Cascade Delete Related
Records in the Edit Relationships dialog box will cause primary key updates and deletes in ____
to be automatically executed in ____.
a. | the related table; the primary table | b. | the primary table; the related
table | c. | either the primary or related table; the other table | d. | None of the
above |
|
|
|
30.
|
To print a report showing the relationships among tables, click the Relationship
Report button, which is located in the
a. | Relationships group of the Relationship Tools Design tab. | b. | Tools group of the
Relationship Tools Design tab. | c. | Analyze group of the Database Tools
tab. | d. | Reports group of the Create tab. |
|
|
|
31.
|
Once a relationship has been established between tables, clicking the
Relationships button causes the ____ to display.
a. | Show Table dialog box | b. | Edit Relationships dialog
box | c. | Relationship Report | d. | Relationships
window |
|
|
|
32.
|
Which of the following statements regarding relationships among tables is
true?
a. | A table can contain a primary key field that is on the “one” side of a
one-to-many relationship as well as a field that is on the “many” side of a different
one-to-many relationship. | b. | A table can contain multiple fields that are
each on the “many” side of a one-to-many relationship. | c. | The primary key of a
primary table can participate in more than one one-to-many relationships. | d. | All of the
above |
|
|
|
33.
|
In one-to-many relationships, the ____ is identified as the “one”
and the ____ is identified as the “many.”
a. | primary key; foreign key | b. | smaller field; larger field | c. | larger field;
smaller field | d. | foreign key; primary key |
|
|
|
34.
|
Relationships between tables are edited here.
a. | Relationships window | b. | Edit Relationships dialog
box | c. | Relationship Report | d. | Table Design
view |
|
|
|
35.
|
What happens when you right-click a relationship line in the Relationships
window, and then choose Delete from the pop-up menu?
a. | Both tables are deleted. | b. | You are prompted to confirm the
deletion. | c. | The relationship is deleted. | d. | The common fields in both tables are
deleted. |
|
|
|
36.
|
Which of the following statements regarding one-to-one relationships is
true?
a. | They are created in Table Design view rather than the Relationships
window. | b. | They are more common than one-to-many relationships. | c. | They result in less
redundant data than one-to-many relationships. | d. | None of the
above |
|
|
|
37.
|
In which situation would a one-to-one relationship be helpful?
a. | when you need to divide a table with many fields into two separate
tables | b. | when have several small tables, each holding data about a particular
subject | c. | when you need to split a table with many records into two separate
tables | d. | All of the above |
|
|
|
38.
|
When a relationship is established between two tables, a subdatasheet displays
fields from
a. | either the related or the primary table as chosen by the user. | b. | the primary
table. | c. | both the related and primary tables. | d. | the related
table. |
|
|
|
39.
|
Data in a subdatasheet can be
a. | collapsed. | b. | viewed. | c. | edited. | d. | All of the
above |
|
|
|
40.
|
The plus symbols (+) in a subdatasheet are referred to as
a. | command buttons. | b. | expand indicators. | c. | join
lines. | d. | collapse indicators. |
|
|
|
41.
|
If a table has more than one relationship defined, clicking the expand indicator
will display the
a. | most recently view subdatasheet. | b. | Edit Relationship dialog
box. | c. | Insert Subdatasheet dialog box. | d. | Relationships
window. |
|
|
|
42.
|
To display subdatasheets for all the records in your primary table, begin by
clicking the
a. | expand indicator for the first record in the table. | b. | More button in the
Records group in the Home tab. | c. | Filter button in the Sort & Filter group in
the Home tab. | d. | Table tab in the work area. |
|
|
|
43.
|
The Primary Key button is located in the Tools group in the ____ tab.
a. | Create | b. | Table Tools Design | c. | Database
Tools | d. | Home |
|
|
|
44.
|
 In this picture, what would happen if
the Primary Key button were clicked?
a. | Access will automatically check to see if a primary key can be
established. | b. | The user would be prompted to enter the field name to use as the primary
key. | c. | The ClientNumber field would be made the primary key. | d. | The
ClaimNumber field would be made the primary key. |
|
|
|
45.
|
 This icon appears on the ____
button.
a. | Relationships | b. | Show Table | c. | Primary
Key | d. | Edit Relationships |
|
|
|
46.
|
 This image is part of
a. | a Table Design view. | b. | the Relationships window. | c. | the Edit
Relationships dialog box. | d. | a subdatasheet. |
|
|
|
47.
|
 What type of relationship is
illustrated in this picture?
a. | one-to-many | b. | one-to-one | c. | many-to-many | d. | indeterminate |
|
|
|
48.
|
 Which field in this illustration would
be considered the foreign key?
a. | ClientNumber in the Clients table | b. | Client in the
Clients table | c. | ClaimNumber in the Claims
table | d. | ClientNumber in the Claims table |
|
|
|
49.
|
 This icon appears on the ____
button.
a. | Relationship Report | b. | Primary Key | c. | Edit
Relationships | d. | Relatonships |
|
|
|
50.
|
 Clicking the button that contains this
icon will
a. | display the Show Table dialog box. | b. | print the Relationships
report. | c. | make the selected field a primary key field. | d. | display the
Relationships window. |
|