 |
| 1 | |
Which of the following represents the different information formats? |
| | A) | Individual, department, enterprise |
| | B) | Detail, summary, aggregate |
| | C) | Document, presentation, spreadsheet, database |
| | D) | None of the above |
|
|
|
| 2 | |
What in the relational database model is a person, place, thing, transaction, or event about which information is stored? |
| | A) | Attribute |
| | B) | Attribute class |
| | C) | Entity |
| | D) | Entity class |
|
|
|
| 3 | |
All of the following are advantages of database-stored information, except: |
| | A) | Increased information redundancy |
| | B) | Increased performance |
| | C) | Increased information integrity |
| | D) | Increased flexibility |
|
|
|
| 4 | |
What measures how quickly a system performs a certain process or transaction? |
| | A) | Redundancy |
| | B) | Information integrity |
| | C) | Scalability |
| | D) | Performance |
|
|
|
| 5 | |
What are the rules that help ensure the quality of information? |
| | A) | Relational integrity constraints |
| | B) | Information integrity |
| | C) | Integrity constraints |
| | D) | Business-critical integrity constraints |
|
|
|
| 6 | |
Which of the following is a primary component in a DBMS? |
| | A) | Data definition component |
| | B) | Data manipulation component |
| | C) | Application generation component |
| | D) | All of the above |
|
|
|
| 7 | |
Which of the following describes ETL? |
| | A) | A process that transforms information using a common set of enterprise definitions |
| | B) | A process that loads information into a data warehouse |
| | C) | A process that extracts information from internal and external databases |
| | D) | All of the above |
|
|
|
| 8 | |
What is data mining? |
| | A) | A particular attribute of information |
| | B) | The common term for the representation of multidimensional information |
| | C) | The process of analyzing data to extract information not offered by the raw data alone |
| | D) | Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making |
|
|
|
| 9 | |
Which of the following is one of the principal BI enablers? |
| | A) | Management information systems |
| | B) | Corporate processes |
| | C) | Customers |
| | D) | Corporate culture |
|
|
.