|
1 | | Select the correct order of complexity of the following data categories from least complex to most complex |
|
| | A) | field, character, file, record, database |
| | B) | character, record, field, database, file |
| | C) | file, database, record, character, field |
| | D) | character, field, record, file, database |
|
2 | | The particular field of a record that uniquely identifies each record is called the |
|
| | A) | key field |
| | B) | primary field |
| | C) | master field |
| | D) | order field |
|
3 | | The software used to specify the logical organization for a database and access it is called |
|
| | A) | data administration software |
| | B) | data manipulation subsystem |
| | C) | data administration subsystem |
| | D) | database management system |
|
4 | | If a user would want access to a restricted database to work on a special project, this is the person they would see to grant them access. |
|
| | A) | data boss |
| | B) | database administrator |
| | C) | data overseer |
| | D) | database executor |
|
5 | | A network database is similar to a hierarchical database with the exception of this feature. |
|
| | A) | query language |
| | B) | many-to-many relationships |
| | C) | parent and child nodes |
| | D) | one-to-many relationships |
|
6 | | Relations between data elements are represented by ______ in a relational database. |
|
| | A) | columns |
| | B) | key fields |
| | C) | tables |
| | D) | files |
|
7 | | The most recently developed database structure is the |
|
| | A) | object-oriented structure |
| | B) | hierarchical structure |
| | C) | network structure |
| | D) | relational structure |
|
8 | | One of the following is not an organizing element in an object oriented database |
|
| | A) | classes |
| | B) | rows |
| | C) | entities |
| | D) | methods |
|
9 | | A database where data is stored in more than one location, often in different locations than where the users are located, is known as a |
|
| | A) | distributed database |
| | B) | network database |
| | C) | decentralized database |
| | D) | Internet database |
|
10 | | A technique for searching special databases, called data warehouses, looking for related information and patterns is called |
|
| | A) | data matching |
| | B) | data query |
| | C) | data banking |
| | D) | data mining |
|
11 | | Batch processing refers to when data is processed at the same time the transaction occurs. |
|
| | A) | True |
| | B) | False |
|
12 | | In a relational database all related tables must have a common data item, also known as a key field, to be linked together. |
|
| | A) | True |
| | B) | False |
|
13 | | A data administrator is a specialist who is responsible for maintaining standards for the development, maintenance, and security of an organization's database. |
|
| | A) | True |
| | B) | False |
|
14 | | Data mining is a software tool that is used to query information in a relational database. |
|
| | A) | True |
| | B) | False |
|
15 | | Hierarchical database structures use pointers, which are simply fields within a record that indicate the location of another record that is related to it in the same file, or in another file. |
|
| | A) | True |
| | B) | False |