 |
1 | |
______ is an example of a database file. |
| | A) | An address book. |
| | B) | A student's social security number. |
| | C) | Name of student. |
| | D) | A mail merge letter created with Word. |
|
|
2 | |
The _____ holds information about one record in a database file. |
| | A) | File. |
| | B) | Field. |
| | C) | Record. |
| | D) | System. |
|
|
3 | |
One advantage of a database is: |
| | A) | The ability to run grammar check. |
| | B) | Information can be easily retrieved, and duplicated data can be easily detected and removed. |
| | C) | The ability to perform automatic calculations. |
| | D) | The ability to do page layouts. |
|
|
4 | |
An electronic database can: |
| | A) | Generate reports. |
| | B) | Search for data strings. |
| | C) | Sort data. |
| | D) | All of the above. |
|
|
5 | |
Boolean operators include the following: |
| | A) | And, Or, What If. |
| | B) | Not, Some, Part. |
| | C) | And, Or, Not. |
| | D) | And, Not, Part. |
|
|
6 | |
An administrator cannot recall the first name of a newly hired man in the accounting department, but recalls his last name is Smith. He does remember the name of everyone else in the department. The administrator has access to the database file below. Which expression, entered into the database, will locate Mr. Smith's information.
| Employee # | Last Name | First Name | Department | Office | | S3 | Smith | Peter | Accounting | 235 | | T2 | Dunlop | Michael | HR | 104 | | P4 | Duran | Peggy | HR | 106 | | N2 | Smith | Richard | Accounting | 248 | | N3 | Morrison | Don | Accounting | 206 | | T4 | Duran | Hector | HR | 105 |
|
| | A) | Smith AND Accounting |
| | B) | Smith OR Accounting |
| | C) | Smith AND Accounting NOT Peter. |
| | D) | Smith Not Peter |
|
|
7 | |
Which of the following symbols is for a wild card. |
| | A) | = |
| | B) | @ |
| | C) | > |
| | D) | * |
|
|
8 | |
A wild card, such as an asterisk, allows the user to search with partial information. Which of the following records would NOT meet the search criteria and NOT be retrieved when you search for *ban*? |
| | A) | Bank |
| | B) | Urbanite |
| | C) | Enable |
| | D) | Bandages |
|
|
9 | |
The hierarchical database was one of the first methods of database organization. Which statement is true about this type of database organization? |
| | A) | Information is stored in a top-to-bottom organizational structure. |
| | B) | Fields can be added or deleted easily. |
| | C) | There are many different paths to a given field. |
| | D) | None of the above. |
|
|
10 | |
Which was the first program to integrate data organization with graphics? |
| | A) | AppleWorks |
| | B) | Access |
| | C) | FileMaker Pro |
| | D) | HyperCard |
|
|
11 | |
Which type of database lets the user work with more than one file at a time, and helps control data redundancy? |
| | A) | Relational database. |
| | B) | Network database. |
| | C) | Free-Form database. |
| | D) | Flat-File database. |
|
|
12 | |
Students who understand how to manipulate a database can: |
| | A) | Find patterns. |
| | B) | Draw relationships. |
| | C) | Identify trends. |
| | D) | All of the above. |
|
|
13 | |
Two commonly used databases in the classroom are: |
| | A) | FileMaker Pro and Microsoft Access. |
| | B) | Microsoft Access and Excel. |
| | C) | PageMaker and FileMaker Pro. |
| | D) | Microsoft Windows and Linux. |
|
|
14 | |
Which important database concept is most appropriate for elementary students? |
| | A) | Understanding the logic behind database programs. |
| | B) | Knowledge of concrete elements such as Record, Field, and Search. |
| | C) | How to run queries that span multiple files. |
| | D) | All of the above |
|
|
15 | |
A teacher is getting ready to write her midterm evaluations of her students, and wants to use her database of student names, as well as her word processing program, to create personalized letters for each of her students. In each report, she wants to include the student's name and student-specific personalized remarks. What word processing feature should the teacher use to create her reports? |
| | A) | Merge. |
| | B) | File management. |
| | C) | File-sharing. |
| | D) | Sorting. |
|