Multiple choice questions

Need answers to multiple choice practice test so that I can compare my answers. This is not a graded project.

---
1. What is the best way to store an individual's name in a table? (Points: 2)
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? (Points: 2)
Telephone number
Zip code
Social Security number
All of these are correct

3. Which of the following field types can be used in calculations? (Points: 2)
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. (Points: 2)
memo
text
data
long

5. Which view can be used to enter or modify the data in the underlying table? (Points: 2)
Form view
Table Design view
Form Design view
New Table view

6. Which of the following is true about forms? (Points: 2)
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? (Points: 2)
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? (Points: 2)
Redundant data
Program-data independence
Better data quality
Reduced program maintenance

9. Which of the following functions does a database application program perform? (Points: 2)
Create data
Retrieve data
Delete data
All of the above.

10. A rule that can NOT be violated by database users is called a: (Points: 2)
password.
constraint.
program.
view.

11. In a file processing environment, descriptions for data and the logic for accessing the data is built into: (Points: 2)
application programs.
database descriptors.
fields.
records.

12. Older systems that often contain data of poor quality are called _____ systems. (Points: 2)
controlled
legacy
database
mainframe

13. E. F. Codd developed the relational model in the: (Points: 2)
1960s.
1970s.
1980s.
1990s.

14. The most common source of database failures in organizations is: (Points: 2)
lack of planning.
inadequate budget.
inadequate hardware.
failure to implement a strong database administration function.

15. A user view is: (Points: 2)
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: (Points: 2)
Form
Design grid
Report
Datasheet View

17. Which of the following entries in a Design grid will return the record Anderson? (Points: 2)
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. (Points: 2)
memo
numeric
text
object

19. In SQL, the ____________ keyword is used to indicate which fields to include in the data to display. (Points: 2)
FROM
WHERE
SELECT
INCLUDE

20. If you want to access certain records that share some common characteristics, you will need to ____________ the database. (Points: 2)
synchronize
constrain
index
query

21. Which of the following controls is used to enter or modify the data in a table? (Points: 2)
Bound control
Unbound control
Calculated control
Expression control

22. The count function is a type of summary calculation. It calculates: (Points: 2)
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? (Points: 2)
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? (Points: 2)
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: (Points: 2)
second normal form.
a one-to-many relationship.
third normal form.
good normal form.
---