 |
1 | |
An example of a database file would be |
| | A) | An address book |
| | B) | A student's social security number |
| | C) | Name of student |
|
|
2 | |
The record of an employee Smith contains his name, social security number,telephone number, date of birth and employee number. This record contains ____field(s). |
| | A) | 1 |
| | B) | 5 |
| | C) | 6 |
|
|
3 | |
The greatest advantage of a database is |
| | A) | The conversion of all data from paper to electronic form |
| | B) | The ease of information retrieval and reduction of duplicated data |
|
|
4 | |
The use of Boolean logic, and entering [Smith OR Duran NOT Hector], will yield the following employee records out of the database file below: | Employee # | Last Name | First Name | Department | Office | | S3 | Smith | Susan | 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) | S3, N2, P4 |
| | B) | S3, N2 |
| | C) | T2, N3 |
|
|
5 | |
An administrator cannot recall the first name of a newly hired man in the accounting department, but recalls his last name as Smith. Which expression, entered into the database, will yield this specific result from the database file below? | Employee # | Last Name | First Name | Department | Office | | S3 | Smith | Susan | 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 Susan |
|
|
6 | |
You don't need complete information to search for records in a database. |
| | A) | True |
| | B) | False |
|
|
7 | |
A wildcard, 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 |
|
|
8 | |
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 |
|
|
9 | |
Which type of database concepts is appropriate for most elementary students? |
| | A) | The logic behind database programs |
| | B) | Essential concepts such as record, field and search |
| | C) | Queries that span multiple files |
|
|
10 | |
By merging a letter from a word processor with a database containing student namesand teacher remarks, a teacher can give personalized reports to each student. |
| | A) | True |
| | B) | False |
|
2002 McGraw-Hill Higher Education