True/False : Indicate whether the sentence or statement
is true or false.
____ 1. Every table defined in Access must have a
primary key.
____ 2. A primary key that consists of more than
one field is called a composite key.
____ 3. A common field is a field that is defined
as a primary key in one table and is defined as a
foreign
key in a second table.
____ 4. A field name must be unique within a
database.
____ 5. A field name can begin with any character,
including spaces and special characters.
____ 6. Access processes smaller data sizes faster
than larger ones, using less memory, so you
can
optimize your database's performance and its storage space by selecting the
correct
field
size for each field.
____ 7. You may specify a duplicate value for a
primary key if the field is also defined as a
foreign
key in another table.
____ 8. Records in a table are stored on disk in
the order they are entered but are displayed in
primary
key sequence.
____ 9. A primary key is allowed to have a null
value.
____ 10. Certain Access data types have a predefined
field size that cannot be changed.
Multiple Choice
Identify the letter of the choice that best completes the
statement or answers the question.
Figure 2-3
____ 11. Given a relationship between the two tables in
Figure 2-3, in the Position table shown, the ____ field is a redundant field.
a. |
PositionID |
b. |
EmployerID |
c. |
PositionTitle |
d. |
EmployerName |
____ 12. A field name ____.
a. |
must be unique within a table |
b. |
can be up to 128 characters long |
c. |
must start with a space |
d. |
All of the above |
____ 13. Which option from the New Table dialog box
would you select if you wanted to define a table yourself from start to finish?
a. |
Design View |
b. |
Link Table |
c. |
Table Wizard |
d. |
Datasheet View |
____ 14. To begin creating a new table, click the ____
button in the Database window.
a. |
Open |
b. |
New |
c. |
Help |
d. |
Design |
____ 15. If you make a mistake when entering data in a
field, you can erase the characters to the left of the insertion point by
pressing the ____ key.
a. |
left arrow |
b. |
Tab |
c. |
Delete |
d. |
Backspace |
____ 16. A field defined as a yes/no field type will be
displayed as a ____.
a. |
radio button |
b. |
Y or N |
c. |
check box |
d. |
null value |
____ 17. To delete a record from a table, click the
____.
a. |
field selector for any field |
b. |
Cancel button after selecting the row |
c. |
row selector for the record to be
deleted and then click the Delete Record button on the Table Datasheet
toolbar |
d. |
row selector for the Field Name row |
____ 18. In navigation mode, anything you type in a
field ____.
a. |
adds or deletes characters depending on
the location of the insertion point |
b. |
is added to the end of the current field
value |
c. |
replaces the previous value |
d. |
repositions the record within the
database |
____ 19. You move from text box to text box when
designing a table in Design view by pressing the ____ key.
a. |
F1 |
b. |
Esc |
c. |
Tab |
d. |
Alt |
____ 20. Which sequence represents the hierarchy
of terms from smallest to largest?
a. |
Database, table, record, field. |
b. |
Field, record, database table |
c. |
Record, field, table, database |
d. |
Field, record, table, database |
____ 21. The 3 major models of logical data structures
discussed in Chapter 12 are the following
EXCEPT
____________.
a. |
Hierarchical, Network &
Relational models |
b. |
Network, Tree & Branch models |
c. |
Network, Relational & Tree models |
d. |
(a) and (c) only |
____ 22. The main reasons why database management
systems are needed are the following
EXCEPT
__________.
a. |
Integrate various applications within
the system. |
b. |
Standardize various applications within
the system. |
c. |
Provide security for the system |
d. |
All the above are reasons. |
____ 23. ____________________ is used both alone and
with DBMS s to centralize, document, control, and co-ordinate the use of data
within an organization
a. |
Data |
b. |
Data Documentation |
c. |
Data Dictionaries |
d. |
Data Redundancy Report |
____ 24. The elements of database environment in
database management systems include the following EXCEPT ____________.
a. |
Data Administration & Users |
b. |
Database Technology & Management |
c. |
Data Planning & Modeling Methodology |
d. |
All of the above are elements. |
____ 25. When creating a brand new database model, you
used abstract and business perspective
to
design through understanding & establishing users’ needs. This form of database
design
is known as _________________.
a. |
Physical Design |
b. |
Conceptual Design |
c. |
Detailed Design |
d. |
Entity-Relationship Design |