 |
| 1 | |
Which of the following represents the different information formats? |
| | A) | Detail, summary, aggregate |
| | B) | Document, presentation, spreadsheet, database |
| | C) | Individual, department, enterprise |
| | D) | None of the above |
|
|
|
| 2 | |
Which of the following implies that aggregate or summary information is in agreement with detailed information? |
| | A) | Uniqueness |
| | B) | Completeness |
| | C) | Consistency |
| | D) | Accuracy |
|
|
|
| 3 | |
Which of the following can a database maintain information on? |
| | A) | Inventory |
| | B) | Transactions |
| | C) | Employees |
| | D) | All of the above |
|
|
|
| 4 | |
In the relational database model, what are characteristics or properties of an entity class? |
| | A) | Entity |
| | B) | Entity class |
| | C) | Attribute |
| | D) | Attribute class |
|
|
|
| 5 | |
What is the physical view of information? |
| | A) | Deals with the physical storage of information on a storage device such as a hard disk |
| | B) | Deals with the logical storage of information on a storage device such as a hard disk |
| | C) | Focuses on how users logically access information to meet their particular business needs |
| | D) | Focuses on how users physically access information to meet their particular business needs |
|
|
|
| 6 | |
What is an integration? |
| | A) | Allows separate systems to communicate directly with each other |
| | B) | Takes information entered into a given system and sends it to the database |
| | C) | Takes information entered into a given system and sends it to other processes |
| | D) | Takes information entered into a given system and sends it to the DBMS |
|
|
|
| 7 | |
Which of the following describes ETL? |
| | A) | A process that extracts information from internal and external databases |
| | B) | A process that transforms information using a common set of enterprise definitions |
| | C) | A process that loads information into a data warehouse |
| | D) | All of the above |
|
|
|
| 8 | |
Which of the following statements is true? |
| | A) | The more complete an organization wants to get its information, the less it costs |
| | B) | The more accurate an organization wants to get its information, the less it costs |
| | C) | The less accurate an organization wants to get its information, the more it costs |
| | D) | The more complete and accurate an organization wants to get its information, the more it costs |
|
|
|
| 9 | |
What is information that people use to support their decision-making efforts? |
| | A) | Information cleansing and scrubbing |
| | B) | Data-mining tools |
| | C) | Data mining |
| | D) | Business intelligence |
|
|
|
| 10 | |
Why is Ben & Jerry's using business intelligence? |
| | A) | To improve quality |
| | B) | To create new flavors of ice cream |
| | C) | To improve financials |
| | D) | To manage distribution |
|
|
.