Name: 
 

A114/I111 Chapter One Review



Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
 

1. 
The problem(s) using spreadsheets include
a.
they prevent multiple employees from updating data.
b.
they have size limitations.
c.
they have limited security features.
d.
all of the above
 

2. 
A database is a structure that contains information about the
a.
different categories of information.
b.
external files used.
c.
hardware configuration used with the database.
d.
network configuration where data is stored on different PCs.
 

3. 
Another term or definition of an entity is
a.
attribute.
c.
object.
b.
relationship.
d.
property.
 

4. 
Another name for an object for which you want to store and process data is
a.
entity.
c.
field.
b.
attribute.
d.
column.
 

5. 
Another term for an attribute is
a.
row.
c.
entity.
b.
field.
d.
object.
 

6. 
The term relationship can be defined as an association between
a.
fields.
c.
attributes.
b.
columns.
d.
entities.
 

7. 
An example of a one-to-many relationship might be
a.
one sales rep can be associated with many customers.
b.
one sales rep can be associated with zero customers.
c.
one sales rep can be associated with one customer.
d.
all of the above
 

8. 
Spreadsheets, documents, and Web pages are stored in
a.
databases.
c.
entities.
b.
data files.
d.
attributes.
 

9. 
A database can store information about
a.
multiple types of entities.
c.
the relationships among those entities.
b.
the attributes of those entities.
d.
all of the above
 

10. 
The relationship is handled in a database system by using
a.
all of the columns in an entity.
b.
the columns in common among entities.
c.
the data in common among the entities.
d.
all of the rows in an entity.
 

11. 
All of the following are acceptable names for tables except (depending on the database system)
a.
Entities.
c.
Orders.
b.
Order.
d.
Ordering.
 

12. 
One example of a popular DBMS is
a.
Pascal.
c.
.NET.
b.
Java.
d.
SQL Server.
 

13. 
Creating the structure of a database is a process known as
a.
database structure.
c.
database design.
b.
database process.
d.
database query.
 

14. 
A GUI object used to maintain, view, and print data from a database is known as a
a.
screen.
c.
form.
b.
monitor.
d.
window.
 

15. 
A set of special forms used to provide controlled access to the data, forms, reports, and other objects in a database is known as a(n)
a.
switchboard.
c.
access form.
b.
form.
d.
reporter form.
 

16. 
Some advantages of database processing include
a.
sharing data.
c.
expanding security.
b.
controlling redundancy.
d.
all of the above
 

17. 
Integrity constraints mean that the data
a.
is kept in an external file.
b.
must follow set rules in the database.
c.
can be accessed by authorized users.
d.
can unintentionally be accessed by unauthorized users.
 

18. 
When dealing with redundancy, it may be
a.
the ideal to eliminate all redundancy.
b.
possible to eliminate all redundancy.
c.
preferable to have a limited amount of redundancy.
d.
both a and c
 

19. 
A DBA can assign passwords to
a.
all groups.
c.
non-users.
b.
unauthorized users.
d.
only management users.
 

20. 
A database can be accessed by
a.
programmers.
c.
the DBA.
b.
data entry personnel.
d.
all of the above
 

21. 
If the structure of the database can be changed without changing the programs that access the database, it is called
a.
increasing productivity.
c.
providing data independence.
b.
expanding security.
d.
increasing complexity.
 

22. 
There are several disadvantages to database processing.  They include
a.
larger file size.
c.
the need to expand security.
b.
greater impact of failure.
d.
both a and b
 
 
eight_files/i0240000.jpg
 

23. 
What is the figure showing?
a.
Main Switchboard form
c.
Part form
b.
Orders form
d.
None of the above
 
 
eight_files/i0260000.jpg
 

24. 
What is the figure showing?
a.
Main Switchboard form
c.
Part form
b.
Orders form
d.
None of the above
 
 
eight_files/i0280000.jpg
 

25. 
What is the figure showing?
a.
Main Switchboard form
c.
Part form
b.
Orders form
d.
Parts report
 

Completion
Complete each sentence or statement.
 

26. 
A(n) _________________________ is a structure that can store information about multiple types of entities, the attributes of those entities, and the relationships among the entities.
 

 

27. 
A(n) ________________________ is a person, place, object, event, or idea for which you wish to store and process data.
 

 

28. 
A(n) _________________________ is a characteristic or property of an entity.
 

 

29. 
A program, or collection of programs, through which the users interact with a database is known as a(n) ______________________________.
 

 

30. 
A screen object used to maintain, view, and print data from a database is known as a(n) _________________________.
 

 

31. 
A set of special forms used to provide controlled access to the data, forms, reports, and other objects in a database is known as a(n) ________________________.
 

 

32. 
One advantage to using a database processing system is that the data of various users can be combined and ________________________ among authorized users.
 

 

33. 
In a database system, it is important to control ________________________; each piece of data should occur only once in the database.
 

 

34. 
A problem with ________________________ means that the data for an entity not only occurs in more than one place, but differs each time.
 

 

35. 
A(n) ________________________ constraint is a rule that must be followed by data in the database.
 

 

36. 
Data ________________________ is a property that allows you to change the structure of a database without requiring you to change the programs that access the database.