 |
| 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 |
|
|
.