 |
| 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 | |
Data links to Ebay let companies fill their storefronts with inventory, while making transactions over eBay's network. |
| | 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 | |
According to the Real Life Case, ScoutPal is a service that turns electronic pagers into mobile bar-code scanners. |
| | 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 | |
According to the Real Life Case, while most people think of Amazon as the world's largest retailer and biggest bookstore, they are at heart a technology company. |
| | 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 | |
At Emerson Process Management, data analysts in each business unit are tasked with all of the following except: |
| | A) | Establishing and communicating data standards |
| | B) | Ensuring that data integrity is maintained during database conversions |
| | C) | Simplifying complex business processes |
| | D) | Creating a logical design for the data warehouse tables |
|
|
|
| 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 | |
According to the Real World Case, Acxiom Corporation typically stores _______________ of complete customer-history data for clients. |
| | A) | six months |
| | B) | twelve months |
| | C) | three years |
| | D) | seven years |
|
|
.