|
1 | | Generally speaking, fields are organized so that they represent some logical order. |
| | A) | True |
| | B) | False |
|
|
|
2 | | Any grouping of related records in tabular, or row and column form, is called an entity. |
| | A) | True |
| | B) | False |
|
|
|
3 | | A database consolidates records into a common pool of data elements that provides data for a single application. |
| | A) | True |
| | B) | False |
|
|
|
4 | | The network database model can relate data in any one file with data in another file, if both files share a common data element or field. |
| | A) | True |
| | B) | False |
|
|
|
5 | | Relational database management systems cannot process large amounts of business transactions as quickly and efficiently as those based on the hierarchical and network models. |
| | A) | True |
| | B) | False |
|
|
|
6 | | Replication and distribution of databases are done to improve database security at end user worksites. |
| | A) | True |
| | B) | False |
|
|
|
7 | | The primary challenge of a distributed database is the time required to access the records. |
| | A) | True |
| | B) | False |
|
|
|
8 | | When you use a search engine, such as Google or Yahoo!, to look up something on the Internet, you are using an external database. |
| | A) | True |
| | B) | False |
|
|
|
9 | | The database management approach consolidates data records formerly in separate files into databases that can be accessed by a single application program. |
| | A) | True |
| | B) | False |
|
|
|
10 | | A database management system (DBM) controls the creation, maintenance, and use of the databases of an organization and its end users. |
| | A) | True |
| | B) | False |
|
|
|
11 | | The most basic logical data element is the _______________, which consists of a single alphabetic, numeric, or other symbol. |
| | A) | character |
| | B) | bit |
| | C) | entity |
| | D) | byte |
|
|
|
12 | | Which of the following best describes a database? |
| | A) | It is an integrated collection of logically related records or files |
| | B) | It consolidates records previously stored in separate files into a common pool of data records |
| | C) | It includes stored data that is independent of the application programs using it |
| | D) | All of the choices are correct |
|
|
|
13 | | Three basic operations can be performed on a relational database to create useful sets of data. The _______________ operation is used to create a subset of records that meet a stated criterion. |
| | A) | pick |
| | B) | filter |
| | C) | sort |
| | D) | select |
|
|
|
14 | | The multidimensional database model is a variation of the _______________ model. |
| | A) | hierarchical |
| | B) | network |
| | C) | object-oriented |
| | D) | relational |
|
|
|
15 | | An object does which of the following? |
| | A) | Combines the attributes and programs (operations) that can be performed on those attributes. |
| | B) | Separates the attributes and programs (operations) that can be performed on those attributes. |
| | C) | Has no effect on the attributes and programs (operations) that can be performed on those attributes. |
| | D) | None of the above are correct. |
|
|
|
16 | | Checking, savings, and installment lending are the business processes whose data models are part of a larger banking services data model that serves as a _______________ data framework for all bank services. |
| | A) | logical |
| | B) | physical |
| | C) | conceptual |
| | D) | technical |
|
|
|
17 | | According to the text, the physical view of the data may also be called _______________. |
| | A) | the database view |
| | B) | the external view |
| | C) | the internal view |
| | D) | the technical view |
|
|
|
18 | | Acquiring information from various operational and external databases and then cleaning and transforming it into data suitable for analysis involves _______________. |
| | A) | filtering out unwanted data |
| | B) | correcting incorrect data |
| | C) | aggregating data into new data subsets |
| | D) | All of the choices are correct. |
|
|
|
19 | | When the file processing approach became too _______________ to supply the information needed to manage modern business, it was replaced by the database management approach. |
| | A) | cumbersome |
| | B) | inflexible |
| | C) | costly |
| | D) | All of the choices are correct. |
|
|
|
20 | | All the following were problems with the file processing approach, except: |
| | A) | data redundancy |
| | B) | lack of data integration |
| | C) | data independence |
| | D) | lack of data integrity |
|
|