Multiple choice questions
1. What is the best way to store an individual's name in a table?
As three separate fields for first name, last name, and middle initial
As two fields, one for the last name, and one for the first name and middle initial
As a single field consisting of the first name, last name, and middle initial, in that order
As a single field consisting of the last name, first name, and middle initial, in that order
2. Which of the following should be defined as a text field?
Telephone number
Zip code
Social Security number
All of these are correct
3. Which of the following field types can be used in calculations?
Number
Currency
Both Number and Currency
Neither Number nor Currency
4. If you wanted to store text data that may be very long, you would put it into a ____________ field.
memo
text
data
long
5. Which view can be used to enter or modify the data in the underlying table?
Form view
Table Design view
Form Design view
New Table view
6. Which of the following is true about forms?
Forms consist of controls that accept and display data
A form has different views
A form provides an easy way to enter and display data.
All of these are correct
7. Which of the following decisions must be made when developing a personal computer database?
Buy or make
Database design
Who is responsible for data accuracy
All of the above.
8. Which of the following is NOT an advantage of database systems?
Redundant data
Program-data independence
Better data quality
Reduced program maintenance
9. Which of the following functions does a database application program perform?
Create data
Retrieve data
Delete data
All of the above.
10. A rule that can NOT be violated by database users is called a:
password.
constraint.
program.
view.
11. In a file processing environment, descriptions for data and the logic for accessing the data is built into:
application programs.
database descriptors.
fields.
records.
12. Older systems that often contain data of poor quality are called _____ systems.
controlled
legacy
database
mainframe
13. E. F. Codd developed the relational model in the:
1960s.
1970s.
1980s.
1990s.
14. The most common source of database failures in organizations is:
lack of planning.
inadequate budget.
inadequate hardware.
failure to implement a strong database administration function.
15. A user view is:
what a user sees when he or she looks out the window.
a table or set of tables.
a logical description of some portion of the database.
a procedure stored on the server.
16. The results of a query are displayed in a:
Form
Design grid
Report
Datasheet View
17. Which of the following entries in a Design grid will return the record Anderson?
Ander?
Ander*
Both Ander? and Ander*
Neither Ander? nor Ander*
18. If you wanted to record a salary and use it in future calculations, you would put it into a ____________ field.
memo
numeric
text
object
19. In SQL, the ____________ keyword is used to indicate which fields to include in the data to display.
FROM
WHERE
SELECT
INCLUDE
20. If you want to access certain records that share some common characteristics, you will need to ____________ the database.
synchronize
constrain
index
query
21. Which of the following controls is used to enter or modify the data in a table?
Bound control
Unbound control
Calculated control
Expression control
22. The count function is a type of summary calculation. It calculates:
The total of all values in a specified field
The number of records with an entry in a specified field
The average of values in a field
The number of times the data in a field has been requested through a query
23. If you had a form for your fantasy football team, what type of control would you use to display a players' yards per game average?
Calculated control
Bound control
Unbound control
Graph control
24. A relation that contains no multivalued attributes, and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form?
First
Second
Third
Fourth
25. When the value of every field in a table is dependent on the primary key of that table and nothing else, that table is said to be in:
second normal form.
a one-to-many relationship.
third normal form.
good normal form.