 |
| 1 | |
Referential integrity cannot be set for _______________ relationships. |
| | A) | One-To-One |
| | B) | Indeterminate |
| | C) | One-To-Many |
| | D) | Many-To-Many |
|
|
|
| 2 | |
A relationship is created between how many tables? |
| | A) | One |
| | B) | Two |
| | C) | Three |
| | D) | Any number |
|
|
|
| 3 | |
The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet. |
| | A) | primary, foreign |
| | B) | primary, common |
| | C) | foreign, primary |
| | D) | foreign, common |
|
|
|
| 4 | |
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database. |
| | A) | queries |
| | B) | fields |
| | C) | records |
| | D) | tables |
|
|
|
| 5 | |
In the Relationship window, related fields from each table are connected by a(n) _______________. |
| | A) | default field |
| | B) | linking tables |
| | C) | index |
| | D) | join line |
|
|
|
| 6 | |
Relationships between tables can be graphically viewed in the _______________ window. |
| | A) | Design |
| | B) | Joins |
| | C) | Relationships |
| | D) | Tables |
|
|
|
| 7 | |
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field? |
| | A) | 1 |
| | B) |  <![CDATA[<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/007351926x/537091/05_07a.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (0.0K)</a>]]> |
| | C) | r |
| | D) | None |
|
|
|
| 8 | |
In the Field List of a table, the primary key appears _______________. |
| | A) | bold |
| | B) | italicized |
| | C) | underlined |
| | D) | with key icon |
|
|
|
| 9 | |
What type of relationship is created when you select a primary key in both related tables? |
| | A) | One-To-One |
| | B) | Indeterminate |
| | C) | One-To-Many |
| | D) | Many-To-Many |
|
|
|
| 10 | |
The Table _______________ Wizard analyzes a database and recommends changes for normalization. |
| | A) | Analyzer |
| | B) | Documenter |
| | C) | Cleanup |
| | D) | Normalization |
|
|
.