MIS Chapter 6

What measures how quickly a system performs a certain process or transaction? 1. Performance 2. Information integrity 3. Redundancy 4. Scalability

What are the rules that help ensure the quality of information? 1. Integrity constraints 2. Information integrity 3. Business-critical integrity constraints 4. Relational integrity constraints

What in the relational database model is a person, place, thing, transaction, or event about which information is stored? 1. Attribute class 2. Entity 3. Attribute 4. Foreign Key

What is data mining? 1. 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 2. The process of analyzing data to extract information not offered by the raw data alone 3. The common term for the representation of multidimensional information 4. A particular attribute of information

Which of the following describes ETL? 1. All choices listed 2. A process that loads information into a data warehouse 3. A process that transforms information using a common set of enterprise definitions 4. A process that extracts information from internal and external databases

Which of the following represents the different information formats? 1. No choices listed 2. Detail, summary, aggregate 3. Individual, department, enterprise 4. Document, presentation, spreadsheet, database

All of the following are advantages of database-stored information, except: 1. Increased flexibility 2. Increased information redundancy 3. Increased performance 4. Increased information integrity

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints. 1. True 2. False

Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database. 1. True 2. False

Which of the following uses a DBMS to interact with a database? 1. Users of accounting programs 2. Users of human resource programs 3. Users of marketing programs 4. All of the above

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry. 1. True 2. False

Which of the following describes ETL? 1. A process that extracts information from internal and external databases 2. A process that transforms information using a common set of enterprise definitions 3. A process that loads information into a data warehouse 4. All of the above

Which of the following is incorrect in reference to a database? 1. Can be relational or network 2. Information is accessed by logical structure 3. Information is accessed by physical structure 4. Users can access different views of information

Which of the following is not one of the five characteristics common to high quality information? 1. Accuracy 2. Completeness 3. Quantity 4. Consistency

What is information that people use to support their decision-making efforts? 1. Information cleansing and scrubbing 2. Data-mining tools 3. Data mining 4. Business intelligence

Why is Ben & Jerry's using business intelligence? 1. To improve quality 2. To create new flavors of ice cream 3. To improve financials 4. To manage distribution

What are the rules that help ensure the quality of information? 1. Information integrity 2. Integrity constraints 3. Relational integrity constraints 4. Business-critical integrity constraints

What is a primary key? 1. A field (or group of fields) that uniquely identifies a given entity in a table 2. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 3. Characteristics or properties of an entity 4. A field (or group of fields) that uniquely identifies a given attribute in a table

One of the advantages found in a relational database is increased information redundancy. 1. True 2. False

The Data Warehousing Institute estimates that low-quality information costs U.S. businesses $60 billion annually. 1. True 2. False

What is an integration? 1. Allows separate systems to communicate directly with each other 2. Takes information entered into a given system and sends it to the database 3. Takes information entered into a given system and sends it to other processes 4. Takes information entered into a given system and sends it to the DBMS

Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships? 1. Hierarchical database 2. Network database 3. Relational database model 4. All of the above

What is a foreign key? 1. A field (or group of fields) that uniquely identifies a given entity in a table 2. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 3. Characteristics or properties of an entity 4. A field (or group of fields) that uniquely identifies a given attribute in a table

Which of the following represents the different information formats? 1. Detail, summary, aggregate 2. Document, presentation, spreadsheet, database 3. Individual, department, enterprise 4. None of the above

What is a backward integration? 1. Takes information entered into a given system and sends it to the application generation component 2. Takes information entered into a given system and sends it automatically to all downstream systems and processes 3. Takes information entered into a given system and sends it automatically to all upstream systems and processes 4. Takes information entered into a given system and sends it to the DBMS

Which of the following statements is true regarding customer information? 1. Customer information can exist in several operational systems 2. Customer information in each operational system could change 3. Customer information in each operational system can be different 4. All of the above

All of the following are characteristics of information, except: 1. Transactional 2. Analytical 3. Timeliness 4. Quantity

What provides real-time information in response to query requests? 1. Real-time information 2. Real-time systems 3. Information level 4. All of the above