BUSI 335 -
Management Information Systems Quiz #2
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.
|
||||||||||
|
12. |
A field name ____.
|
||||||||||
|
13. |
Which option from the New Table
dialog box would you select if you wanted to define a table yourself from
start to finish?
|
||||||||||
|
14. |
To begin creating a new table,
click the ____ button in the Database window.
|
||||||||||
|
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.
|
||||||||||
|
16. |
A field defined as a yes/no
field type will be displayed as a ____.
|
||||||||||
|
17. |
To delete a record from a
table, click the ____.
|
||||||||||
|
18. |
In navigation mode, anything
you type in a field ____.
|
||||||||||
|
19. |
The ____ property setting for
number fields stores whole numbers from -32,768 to 32,767 in two bytes.
|
||||||||||
|
20. |
You move from text box to text
box when designing a table in Design view by pressing the ____ key.
|
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 |