Chapter 5,6
review questions
1. Which of the following activities does a CIO
perform?
A. Oversees all uses of information technology.
B. Ensures the strategic alignment of IT with business goals.
C. Ensures the strategic alignment of IT with business objectives.
D. All of these.
A. Oversees all uses of information technology.
B. Ensures the strategic alignment of IT with business goals.
C. Ensures the strategic alignment of IT with business objectives.
D. All of these.
2. Broad functions of a CIO include all of the following
except:
A. Ensuring the delivery of all IT projects, on time and within budget.
B. Ensuring that the strategic vision of IT is in line with the strategic vision of the organization.
C. Building and maintaining strong executive relationships.
D. Building and maintaining strong customer processes.
A. Ensuring the delivery of all IT projects, on time and within budget.
B. Ensuring that the strategic vision of IT is in line with the strategic vision of the organization.
C. Building and maintaining strong executive relationships.
D. Building and maintaining strong customer processes.
3. Which
issue concerns CIOs the most?
A. Security.
B. Budgeting.
C. Enhancing customer satisfaction.
D. Marketing.
A. Security.
B. Budgeting.
C. Enhancing customer satisfaction.
D. Marketing.
4. Who is responsible for ensuring the throughput, speed,
accuracy, availability, and reliability of an organization's information
technology?
A. CIO
B. CPO
C. CTO
D. CSO
A. CIO
B. CPO
C. CTO
D. CSO
5. Who
is responsible for ensuring the security of IT systems and developing
strategies and IT safeguards against attacks from hackers and viruses?
A. CIO
B. CPO
C. CTO
D. CSO
A. CIO
B. CPO
C. CTO
D. CSO
6. What are the principles and standards that guide our
behavior toward other people?
A. Intellectual property
B. Copyright
C. Pirated software
D. Ethics
A. Intellectual property
B. Copyright
C. Pirated software
D. Ethics
7. What
is a broad term encompassing the protection of information from accidental or
intentional misuse by persons inside or outside an organization?
A. Ethics
B. Privacy
C. Copyright
D. Information security
A. Ethics
B. Privacy
C. Copyright
D. Information security
8. Jeremy
Bridges is an executive for Green Web Designs, where his primary role is to
ensure the security of business systems and develop strategies to protect the
company from online viruses and hackers. What is Jeremy's role within the
company?
A. Chief Executive Officer (CEO).
B. Chief Security Officer (CSO).
C. Chief Procurement Officer (CPO).
D. Chief Technology Officer (CTO).
A. Chief Executive Officer (CEO).
B. Chief Security Officer (CSO).
C. Chief Procurement Officer (CPO).
D. Chief Technology Officer (CTO).
9. Which
role within a company is responsible for overseeing all uses of MIS and
ensuring that MIS strategy aligns with business goals and objectives?
A. Chief knowledge officer (CKO).
B. Chief privacy officer (CPO).
C. Chief information officer (CIO).
D. Chief security officer (CSO).
A. Chief knowledge officer (CKO).
B. Chief privacy officer (CPO).
C. Chief information officer (CIO).
D. Chief security officer (CSO).
10. What are the different types of information?
A. Levels, forms, granularities
B. Levels, forms, data
C. Levels, formats, granularities
D. Data, formats, granularities
A. Levels, forms, granularities
B. Levels, forms, data
C. Levels, formats, granularities
D. Data, formats, granularities
11. Which
of the following represents the different information levels?
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these
12. 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 these
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these
13. Which
of the following represents the different information granularities?
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these
14. All of the following are characteristics of information
except:
A. Transactional
B. Analytical
C. Timeliness
D. Quantity
A. Transactional
B. Analytical
C. Timeliness
D. Quantity
15. What encompasses all of the information contained within
a single business process or unit of work and its primary purpose is to support
the performance of daily operational tasks?
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality
16. Which
of the following is an example of transactional information?
A. Withdrawing cash from an ATM
B. Making an airline reservation
C. Purchasing stock
D. All of these
A. Withdrawing cash from an ATM
B. Making an airline reservation
C. Purchasing stock
D. All of these
17. What encompasses all organizational information and its
primary purpose is to support the performance of managerial analysis
tasks?
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality
18. Which
of the following is an example of transactional information?
A. Trend projection
B. Sales projection
C. Purchasing stock
D. All of these
A. Trend projection
B. Sales projection
C. Purchasing stock
D. All of these
19. What
is immediate, up-to-date information?
A. Real-time information
B. Real-time systems
C. Information granularity
D. All of these
A. Real-time information
B. Real-time systems
C. Information granularity
D. All of these
20. Which
of the following is not one of the five characteristics common to high-quality
information?
A. Accuracy
B. Completeness
C. Quantity
D. Consistency
A. Accuracy
B. Completeness
C. Quantity
D. Consistency
21. Which of the following implies that aggregate or summary
information is in agreement with detailed information?
A. Uniqueness
B. Completeness
C. Consistency
D. Accuracy
A. Uniqueness
B. Completeness
C. Consistency
D. Accuracy
22. Which of the following implies that information is
current with respect to the business requirement?
A. Uniqueness
B. Accuracy
C. Consistency
D. Timeliness
A. Uniqueness
B. Accuracy
C. Consistency
D. Timeliness
23. What is a real-time system?
A. Provides immediate, up-to-date information.
B. Provides real-time information in feedback to query requests.
C. Encompasses all organization information, and its primary purpose is to support the performance of managerial analysis tasks.
D. Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performance of daily operational tasks.
A. Provides immediate, up-to-date information.
B. Provides real-time information in feedback to query requests.
C. Encompasses all organization information, and its primary purpose is to support the performance of managerial analysis tasks.
D. Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performance of daily operational tasks.
24. Organizational information comes at different levels and
in different formats and granularities.
True False
True False
25. Reports
for each salesperson, product, and part are examples of detailed, or fine,
information granularities.
True False
True False
26. Purchasing stocks is an example of analytical
information.
True False
True False
27. 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.
True False
True False
28. Timely information must be up-to-the-second to be
accurate.
True False
True False
29. Organizational information comes in different ___Levels________,
formats, and granularities.
________________________________________
________________________________________
30. Detail, summary, and ____aggregate_____ are the typical
information granularities.
________________________________________
________________________________________
---------------------------------------------------------------------------------------------------------------------
Chapter 7 – Review Questions
Student:
___________________________________________________________________________
1. Which
of the following types of information can be found in a database?
A. Inventory
B. Transactions
C. Employees
D. All of these
A. Inventory
B. Transactions
C. Employees
D. All of these
2. Which
of the following database structures stores information in a treelike structure
that allows repeating information using parent/child relationships, in such a
way that it cannot have too many relationships?
A. Hierarchical database
B. Network database
C. Relational database model
D. All of these
A. Hierarchical database
B. Network database
C. Relational database model
D. All of these
3. Which
of the following database structures offers a flexible way of representing
objects and their relationships?
A. Hierarchical database
B. Network database
C. Relational database model
D. All of these
A. Hierarchical database
B. Network database
C. Relational database model
D. All of these
4. In the
relational database model, what is a person, place, thing, transaction, or
event about which information is stored?
A. Entity
B. Logical view
C. Attribute
D. Physical view
A. Entity
B. Logical view
C. Attribute
D. Physical view
5. In the
relational database model, what is a characteristic or property of an
entity?
A. Entity
B. Logical view
C. Attribute
D. Physical view
A. Entity
B. Logical view
C. Attribute
D. Physical view
6. What
are characteristics or properties of an entity called?
A. Attributes
B. Fields
C. Columns
D. All of these
A. Attributes
B. Fields
C. Columns
D. All of these
7. Why do
relational databases use primary keys and foreign keys?
A. To create a database.
B. To create physical relationships.
C. To create logical relationships.
D. All of these.
A. To create a database.
B. To create physical relationships.
C. To create logical relationships.
D. All of these.
8. What
is a primary key?
A. A field (or group of fields) that uniquely identifies a given entity in a table.
B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
C. Characteristics or properties of an entity.
D. A field (or group of fields) that uniquely identifies a given attribute in a table.
A. A field (or group of fields) that uniquely identifies a given entity in a table.
B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
C. Characteristics or properties of an entity.
D. A field (or group of fields) that uniquely identifies a given attribute in a table.
9. What
is a foreign key?
A. A field (or group of fields) that uniquely identifies a given entity in a table.
B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
C. Characteristics or properties of an entity.
D. A field (or group of fields) that uniquely identifies a given attribute in a table.
A. A field (or group of fields) that uniquely identifies a given entity in a table.
B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
C. Characteristics or properties of an entity.
D. A field (or group of fields) that uniquely identifies a given attribute in a table.
10. All
of the following are advantages of database-stored information except:
A. Increased flexibility
B. Increased performance
C. Increased information redundancy
D. Increased information integrity
A. Increased flexibility
B. Increased performance
C. Increased information redundancy
D. Increased information integrity
11. Which
of the following is incorrect in reference to a database?
A. Can be relational or network.
B. Information is accessed by logical structure.
C. Information is accessed by physical structure.
D. Users can access different views of information.
A. Can be relational or network.
B. Information is accessed by logical structure.
C. Information is accessed by physical structure.
D. Users can access different views of information.
12. 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.
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.
13. Which
of the following is correct in reference to a database?
A. A database can support only one logical view.
B. A database can support many physical views.
C. A database can support many logical views.
D. A database can support up to three logical views.
A. A database can support only one logical view.
B. A database can support many physical views.
C. A database can support many logical views.
D. A database can support up to three logical views.
14. What
refers to how well a system can adapt to increased demands?
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
15. Which
of the following measures how quickly a system performs a certain process or
transaction?
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
A. Scalability
B. Performance
C. Redundancy
D. Information integrity
16. What
is information redundancy?
A. Duplication of information.
B. Storing the same information in multiple places.
C. Storing duplicate information in multiple places.
D. All of these.
A. Duplication of information.
B. Storing the same information in multiple places.
C. Storing duplicate information in multiple places.
D. All of these.
17. What
is the primary problem with redundant information?
A. It is difficult to determine which values are the most current.
B. It is often inconsistent.
C. It is difficult to determine which values are the most accurate.
D. All of these.
A. It is difficult to determine which values are the most current.
B. It is often inconsistent.
C. It is difficult to determine which values are the most accurate.
D. All of these.
18. Which
of the following is true in regard to eliminating redundant information?
A. Uses additional hard disk space.
B. Makes performing information updates harder.
C. Improves information quality.
D. All of these.
A. Uses additional hard disk space.
B. Makes performing information updates harder.
C. Improves information quality.
D. All of these.
19. What
are the rules that help ensure the quality of information?
A. Information integrity
B. Integrity constraints
C. Relational integrity constraints
D. Business-critical integrity constraints
A. Information integrity
B. Integrity constraints
C. Relational integrity constraints
D. Business-critical integrity constraints
20. Which
of the following is a valid type of integrity constraint?
A. Relational-critical integrity constraint
B. Business integrity constraint
C. Relational integrity constraint
D. Business-critical integrity constraint
A. Relational-critical integrity constraint
B. Business integrity constraint
C. Relational integrity constraint
D. Business-critical integrity constraint
21. What
type of integrity constraint does not allow someone to create an order for a
nonexistent customer?
A. Relational integrity constraint
B. Business-critical integrity constraint
C. Information-critical integrity constraint
D. None of these
A. Relational integrity constraint
B. Business-critical integrity constraint
C. Information-critical integrity constraint
D. None of these
22. All
of the following are business-critical integrity constraints except:
A. The system will not allow an entry for an order for a nonexistent customer.
B. The system will not allow returns of fresh produce after 15 days past delivery.
C. The system will not allow shipping a product to a customer who does not have a valid address.
D. The system will not allow shipping a nonexistent product to a customer.
A. The system will not allow an entry for an order for a nonexistent customer.
B. The system will not allow returns of fresh produce after 15 days past delivery.
C. The system will not allow shipping a product to a customer who does not have a valid address.
D. The system will not allow shipping a nonexistent product to a customer.
23. Which
of the following uses a DBMS to interact with a database?
A. Users of accounting programs
B. Users of human resource programs
C. Users of marketing programs
D. All of these
A. Users of accounting programs
B. Users of human resource programs
C. Users of marketing programs
D. All of these
24. What
type of website is best to build for a general informational website with
static information?
A. Data-driven website
B. Static website
C. Relational website
D. All of these
A. Data-driven website
B. Static website
C. Relational website
D. All of these
25. What
type of website is best to build for a website with continually changing
information, including press releases, new product information, and updated
pricing?
A. Data-driven website
B. Static website
C. Relational website
D. All of these
A. Data-driven website
B. Static website
C. Relational website
D. All of these
26. Which
of the following is not an advantage of building a data-driven website?
A. Minimizes human error.
B. Cuts production and update costs.
C. Improves or maximizes stability.
D. Minimizes or reduces efficiency.
A. Minimizes human error.
B. Cuts production and update costs.
C. Improves or maximizes stability.
D. Minimizes or reduces efficiency.
27. What
is a forward integration?
A. Takes information entered into a given system and sends it to the application-generation component.
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D. Takes information entered into a given system and sends it to the DBMS.
A. Takes information entered into a given system and sends it to the application-generation component.
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D. Takes information entered into a given system and sends it to the DBMS.
28. What
is a backward integration?
A. Takes information entered into a given system and sends it to the application-generation component.
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D. Takes information entered into a given system and sends it to the DBMS.
A. Takes information entered into a given system and sends it to the application-generation component.
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D. Takes information entered into a given system and sends it to the DBMS.
--------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------
Chapter 8 Review
Student:
___________________________________________________________________________
1. A data
warehouse is a _________ collection of information-gathered from many different
___________ databases-that supports business-analysis activities and
decision-making tasks.
A. Physical, transactional
B. Physical, operational
C. Logical, transactional
D. Logical, operational
A. Physical, transactional
B. Physical, operational
C. Logical, transactional
D. Logical, operational
2. What
do data warehouses support?
A. OLAP
B. Analytical processing
C. OLTP
D. OLAP and analytical processing
A. OLAP
B. Analytical processing
C. OLTP
D. OLAP and analytical processing
3. 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 these.
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 these.
4. What
is data mining?
A. The common term for the representation of multidimensional information.
B. A particular attribute of information.
C. 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.
D. Process of analyzing data to extract information not offered by the raw data alone.
A. The common term for the representation of multidimensional information.
B. A particular attribute of information.
C. 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.
D. Process of analyzing data to extract information not offered by the raw data alone.
5. When
does information cleansing occur in the data warehouse?
A. During the ETL process.
B. On the information, once it is in the data warehouse.
C. During the ETL process and once it is in the data warehouse.
D. During the ETL process and before it is in the data warehouse.
A. During the ETL process.
B. On the information, once it is in the data warehouse.
C. During the ETL process and once it is in the data warehouse.
D. During the ETL process and before it is in the data warehouse.
6. Which
of the following statements is true regarding customer information?
A. Customer information can exist in several operational systems.
B. Customer information in each operational system could change.
C. Customer information in each operational system can be different.
D. All of these.
A. Customer information can exist in several operational systems.
B. Customer information in each operational system could change.
C. Customer information in each operational system can be different.
D. All of these.
7. Which
of the following occurs during data cleansing?
A. Clean missing records.
B. Clean redundant records.
C. Clean inaccurate data.
D. All of these.
A. Clean missing records.
B. Clean redundant records.
C. Clean inaccurate data.
D. All of these.
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.
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
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.
A. To improve quality.
B. To create new flavors of ice cream.
C. To improve financials.
D. To manage distribution.
11. Why
is Noodles & Company using business intelligence?
A. To improve financial analysis.
B. To improve corporate processes.
C. To track store quality.
D. To change the corporate culture.
A. To improve financial analysis.
B. To improve corporate processes.
C. To track store quality.
D. To change the corporate culture.
12. Why
would a business use a data warehouse that offers strategic level, external,
integrated, and historical information?
A. Identify trends.
B. Make projections.
C. Decide key business issues.
D. All of these.
A. Identify trends.
B. Make projections.
C. Decide key business issues.
D. All of these.
13. What
is the primary purpose of a data warehouse?
A. To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
B. To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
C. To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
D. To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
A. To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
B. To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
C. To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
D. To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
14. Lands'
End created an organization-wide data warehouse so all its employees could
access organizational information. Lands' End soon found out that there could
be "too much of a good thing." Many of its employees would not use
the data warehouse, because it was simply too big, too complicated, and had too
much irrelevant information. Lands' End knew there was valuable information in
its data warehouse, and it had to find a way for its employees to easily access
the information. What was Lands' End's solution?
A. Build a better, more efficient data warehouse.
B. Build a better, more efficient transactional database.
C. Build a data mart.
D. Build a data-driven website.
A. Build a better, more efficient data warehouse.
B. Build a better, more efficient transactional database.
C. Build a data mart.
D. Build a data-driven website.
15. A
relational database contains information in a series of two-dimensional tables.
How is data contained in a data warehouse and data mart?
A. Information is multidimensional, meaning it contains a single layer of data in a table format.
B. Information is two-dimensional, meaning it contains a single layer of data in a table format.
C. Information is two-dimensional, meaning it contains layers of columns and rows.
D. Information is multidimensional, meaning it contains layers of columns and rows.
A. Information is multidimensional, meaning it contains a single layer of data in a table format.
B. Information is two-dimensional, meaning it contains a single layer of data in a table format.
C. Information is two-dimensional, meaning it contains layers of columns and rows.
D. Information is multidimensional, meaning it contains layers of columns and rows.
16. What
is a dimension?
A. A particular attribute of information.
B. A particular entity of information.
C. A particular relational database.
D. A particular single repository.
A. A particular attribute of information.
B. A particular entity of information.
C. A particular relational database.
D. A particular single repository.
17. A
dimension is a particular attribute of information. Each layer in a data
warehouse or data mart represents information according to an additional
dimension. What is the common term for the representation of multidimensional
information?
A. Table
B. Block
C. Cube
D. All of these
A. Table
B. Block
C. Cube
D. All of these
18. Which
of the following are the principle BI enablers?
A. Technology, processes, and customer culture
B. Technology, people, and customer culture
C. Technology, processes, and corporate culture
D. Technology, people, and corporate culture
A. Technology, processes, and customer culture
B. Technology, people, and customer culture
C. Technology, processes, and corporate culture
D. Technology, people, and corporate culture
19. The
primary purpose of a data warehouse is to perform transactional
processes.
True False
True False
20. A dimension
is a particular attribute of information.
True False
True False
--------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Chapter 9 review
Student:
___________________________________________________________________________
1. Which
of the following is not a reason for the growth of decision-making information
systems?
A. People need to analyze large amounts of information.
B. People must make decisions quickly.
C. People must apply sophisticated analysis techniques to make good decisions.
D. People no longer have to worry about protecting the corporate asset of organizational information.
A. People need to analyze large amounts of information.
B. People must make decisions quickly.
C. People must apply sophisticated analysis techniques to make good decisions.
D. People no longer have to worry about protecting the corporate asset of organizational information.
2. What
can a model accomplish?
A. Calculate risks
B. Understand uncertainty
C. Manipulate time
D. All of these
A. Calculate risks
B. Understand uncertainty
C. Manipulate time
D. All of these
3. Which
of the following is a quantitative model typically used by a DSS?
A. Sensitivity analysis
B. What-if analysis
C. Goal-seeking analysis
D. All of these
A. Sensitivity analysis
B. What-if analysis
C. Goal-seeking analysis
D. All of these
4. What
is the study of the effect that changes in one (or more) part of the model has
on other parts of the model?
A. Drill-down
B. Sensitivity analysis
C. Statistical analysis
D. Goal-seeking analysis
A. Drill-down
B. Sensitivity analysis
C. Statistical analysis
D. Goal-seeking analysis
5. What
finds the inputs necessary to achieve a goal, such as a desired level of
output?
A. Drill-down
B. Sensitivity analysis
C. What-if analysis
D. Goal-seeking analysis
A. Drill-down
B. Sensitivity analysis
C. What-if analysis
D. Goal-seeking analysis
6. What
is consolidation?
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.
7. What
is drill-down capability?
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.
8. What
is slice-and-dice capability?
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.
9. What
integrates information from multiple components and tailors the information to
individual preferences?
A. Drill-down
B. Sensitivity analysis
C. What-if analysis
D. Digital dashboard
A. Drill-down
B. Sensitivity analysis
C. What-if analysis
D. Digital dashboard
10. What
are various commercial applications of artificial intelligence?
A. Drill-down
B. Sensitivity analysis
C. Digital dashboard
D. Intelligent systems
A. Drill-down
B. Sensitivity analysis
C. Digital dashboard
D. Intelligent systems
11. What
is a category of AI that attempts to emulate the way the human brain
works?
A. Intelligent system
B. Artificial intelligence
C. Expert systems
D. Neural network
A. Intelligent system
B. Artificial intelligence
C. Expert systems
D. Neural network
12. Which
of the following is the most commonly used form of AI in the business
arena?
A. Intelligent system
B. Artificial intelligence
C. Expert system
D. Neural network
A. Intelligent system
B. Artificial intelligence
C. Expert system
D. Neural network
13. What
is a special-purpose, knowledge-based information system that accomplishes
specific tasks on behalf of its users?
A. Intelligent system
B. Artificial intelligence
C. Neural network
D. Intelligent agent
A. Intelligent system
B. Artificial intelligence
C. Neural network
D. Intelligent agent
14. What
is an artificial intelligence system that mimics the evolutionary,
survival-of-the-fittest process to generate increasingly better solutions to a
problem?
A. Intelligent system
B. Artificial intelligence
C. Neural network
D. Genetic algorithm
A. Intelligent system
B. Artificial intelligence
C. Neural network
D. Genetic algorithm
15. Which
of the following represents the top-down (executives to analysts)
organizational levels of information technology systems?
A. TPS, DSS, EIS.
B. DSS, TPS, EIS.
C. EIS, DSS, TPS.
D. None of these. It varies from organization to organization.
A. TPS, DSS, EIS.
B. DSS, TPS, EIS.
C. EIS, DSS, TPS.
D. None of these. It varies from organization to organization.
16. Which
of the following is a type of transaction-processing system?
A. Order processing
B. Sales
C. Manufacturing
D. Transportation
A. Order processing
B. Sales
C. Manufacturing
D. Transportation
17. Which
of the following is a type of decision-support system?
A. Order processing
B. Inventory tracking
C. Manufacturing
D. All of these
A. Order processing
B. Inventory tracking
C. Manufacturing
D. All of these
18. A
genetic algorithm is an artificial intelligence system that mimics the
evolutionary, survival-of-the-fittest process to generate increasingly better
solutions to a problem.
True False
True False
19. The
ultimate goal of AI is to build a system that can mimic human
intelligence.
True False
True False
20. Sensitivity
analysis, what-if analysis, and market-basket analysis are the three
quantitative models typically used by a DSS.
True False
True False
21. Consolidation,
drill-down, and slice-and-dice are the three most common capabilities offered
in an EIS.
True False
True False
22. A(n)
___________ is a simplified representation or abstraction of reality.
________________________________________
________________________________________
23. ___________ analysis occurs when users change the
value of one variable repeatedly and observe the resulting changes in other
variables.
Answer:
Sensitivity
24. __________ analysis checks the impact of a change
in an assumption on the proposed solution.
Answer:
What-if
25. _________ analysis could answer the question
"How many customers are required to purchase our new product line to
increase gross profits to $5 million?"
Answer:
Goal-seeking
26. Fuzzy Logic __ is a
mathematical method of handling imprecise or subjective information.
________________________________________
________________________________________
27. Intelligent system ___
are various commercial applications of artificial intelligence.
________________________________________
________________________________________
28. Artificial
intelligence simulates ______________ intelligence, such as the ability to
reason and learn.
________________________________________
________________________________________
29. Expert Systems __ are
computerized advisory programs that imitate the reasoning processes of experts
in solving difficult problems.
________________________________________
________________________________________
30. A(n)
_________ agent is a special-purpose knowledge-based information system that
accomplishes specific tasks on behalf of its users.
________________________________________
________________________________________