NC DESK DATABASE PRACTICE TEST

Pick the letter of the correct answer.

1. Which occupation would most likely use a database on the job?

A. An athlete

B. The janitor at Hudson Belk

C. Telephone information operators

D. Heavy equipment operator

2. Which of the following is not a good use for a database program?

A. Keeping school records

B. Completing a paper for English class

C. Maintaining hospital admission records

D. Organizing recipes at home

3. An advantage of a database program is:

A. Office correspondence can be handled

B. All fields can be printed in a one page report

C. Data can be added or deleted easily

D. All records can be displayed at one time

4. A database program replaces what piece of office equipment?

A. typewriter

B. photocopier

C. FAX machine

D. filing cabinet

5. In a database program, a set of related information is called a:

A. field

B. entry

C. record

D. file

6. Which of the following is not true of database programs?

A. They can be viewed in different formats.

B. They can be used to retrieve information quickly.

C. They are limited to the amount of information they can hold.

D. They can be used by just about anybody.

7. Searching a database of North Carolina counties by using the statement, “all counties with a population of greater that two million” will include:

A. Counties with exactly two million people

B. Counties with two million or more

C. Counties with more than two million

D. Counties with less than two million

8. If a student sorted the following in descending order, which international capital would be first?

A. Moscow

B. Beirut

C. Paris

D. Bogota

9. All of the following are examples of electronic databases except which one?

A. collection of country music CDs

B. a CD-Rom encyclopedia

C. computerized student information

D. Electronic Card Catalog

10. Which search of an electronic phone directory would find only the Doe families living on Main Street in area code 919?

A. Name = Doe and Address = Main Street or Area Code = 919

B. Name = Doe and Address = Main Street and Area Code = 919

C. Name = Doe or Address = Main Street and Area Code

D. Name = Doe or address = Main Street or Area Code = 919

11.  What would you do to generate a hard copy of a database of North Carolina ?

A. Edit the file

B.  Print the file

C.  Retrieve the file

D.  Save the file to a floppy disk

Use the database above to answer

Questions 12-16

12. In what order has the field “Hours” been sorted?

A random

B. alphabetical

C. ascending

D.  descending

13. If a search was completed to determine “Year” = 1968, how many records would match?

A. 5

B. 3

C. 2

D. 6

14. Finding USA flights in the Year 1968 would require a:

A. compound search with AND

B. compound search with OR

C. compound sort with AND

D. compound sort with OR

15. The following search was performed:

“Country” = USSR or “Country” = USA

How many records matched?

A. 9

B. 6

C. 7

D. 8

16. If you wanted to rank the flights in order of most recent to oldest, you would:

A. Search “Year” ascending

B. Search “Craft” ascending

C. Search “Year” descending

D. Search “Craft” descending

17. In a database containing information about North Carolina and its counties, how would you find the county with the most people?

A.  Filter the population field using greater than 10,000.

B. Rank the counties by name and scroll through the list.

C. Search each county record

D.  Sort the records by population in descending order

18. How would you find the phone number of one student from 500 names and addresses of students enrolled at your school?

A.  Perform a search of all boys in the database

B.  Perform a search using the student's name as the criteria

C.  Sort the database and scroll all records

D.  Sort the database in descending order

19. What does searching a database mean?

A. Editing data entries

B. Looking for records that meet certain conditions

C. Opening the file for viewing

D. Ranking the records in the order you need

20. What would be the most efficient way to locate the records for all students born before 08/29/90?

A. Replace

B. Scroll

C. search

D. sort