Font size
WorksheetsMIS Chap 6 Quiz
Total questions: 85
Worksheet time: 55mins
Which of the following statements is true about business intelligence?
It is an act of outsourcing tasks, traditionally performed by an employee or contractor, to an undefined, large group of people or community, through the use of information technology.
It is the process by which a customer-owned mutual organization or cooperative changes legal form to a joint stock company.
It is the use of information systems to gather and analyze information from internal and external sources in order to make better business decisions.
It is an organization's process of defining its strategy, or direction, and making decisions on allocating its resources to pursue this strategy, including its capital and people.
It is the use of human resources to gather and analyze information from external sources in order to make better business decisions.
"Backward looking" budgets are typically based on ________.
forecasts
marketing research
future trends
historical data
current market conditions
Responding to threats and opportunities and continuous planning are based on analyzing internal data primarily from the ________ level of an organization.
operational
executive
tactical
business
strategic
When we consider entities as tables, each row is a ________.
field
record
bot
form
query
When we consider entities as tables, each column is a(n) ________.
attribute
record
form
applet
query
An attribute is also referred to as a ________.
form
record
field
query
bot
A ________ is a collection of related attributes about a single instance of an entity.
bot
form
query
field
record
In a database management system (DBMS), data are kept separate from the application's programming code. This means that ________.
an application cannot be changed without making changes to the database
an application's programming code needs to be updated continuously to keep up with the database
an application needs to be changed when the database is changed
the database does not need to be changed if a change is made to an application
the database needs to be changed when a change is made to an application
One of the advantages of a database approach is program-data independence. This means that it is ________.
easier to deploy and control data access using a centralized system
easier to evolve and alter software to changing business needs when data and programs are independent
a centralized system, thereby making it easier to enforce access restrictions
a centralized system, thereby making it much easier to enforce standards and rules for data creation, modification, naming, and deletion
useful for eliminating redundancy, thereby reducing the possibilities of inconsistency
Identify an advantage when the database approach makes it easier to deploy and control data access.
improved data accessibility
improved data consistency
improved data quality
increased security
improved data sharing
Big Data is ________.
structured data which fit neatly into spreadsheets
semistructured data such as clickstream and sensor data
unstructured data such as audio and video
characterized based on its high velocity
organizational wide data
Data type helps a database management system (DBMS) to ________.
present the data in a useful format
format data
allocate storage space
eliminate data duplication
retrieve information
Once the data model is created, the format of the data is documented in a data ________.
warehouse
entry
mart
domain
dictionary
A data dictionary is also known as ________.
a data mart
a data warehouse
a metadata repository
ubiquitous computing
clickstream data
Bringes, a retail chain, has retail stores across three states. With its current legacy system, Bringes is having problems tracking the inventory levels for its stores. It is planning to implement an Oracle database system to replace this legacy system. Which of the following most supports Bringes' decision to replace its legacy system with an Oracle database system?
Implementing an Oracle database system will require Bringe to hire additional specialized personnel to manage it.
Partial implementation of the Oracle database system can create more problems than it is likely to solve.
Conversion cost required for the implementation of an Oracle database system is not supported by the IT budget.
Bringes' channel partners use a database system that supports the Oracle database system.
Maintenance of an Oracle database system is more expensive than the legacy system presently in use.
Treston, an automobile manufacturer, recently implemented a new database system. It was confident that this system would help enhance the company's internal (employees) and external (customers and channel partners) communication. Treston had planned to pursue a just-in-time inventory system soon after the database system was implemented. After the implementation of the database system, however, Treston realized that the database system was not effective. Which of the following can be cited as a reason for the failure of Treston's database system?
Aerodoungle launched a new version of Enterprise Database Access, which was better than Treston's database system.
The maintenance cost of Treston's new database system was less than the one it was previously using.
Treston's new database system was not supported by the database system of its suppliers and distributors.
Treston's competitors implemented its database a few days prior to Treston's implementation date.
Treston had internally trained personnel managing its new database system, thereby keeping costs low.
Business rules are captured by the designers of a database and included in a data dictionary to ________.
organize and sort the data, complete calculations, and allocate storage space
prevent illegal or illogical entries from entering the database
eliminate data duplication
make sure that each table contains only attributes that are related to an entity
capture the structure of the database
________ are used to capture data to be added, modified, or deleted from a database.
Forms
Reports
Queries
Bots
Layers
A(n) ________ is a compilation of data from a database that is organized and produced in printed format.
form
attribute
field
entity
report
A query is used to ________.
organize and sort the data in a database
allocate storage space for a database
eliminate data duplication
retrieve data from a database
prevent illegal or illogical entries from entering the database
________ systems are designed to handle multiple concurrent transactions from customers.
Online transaction processing
Product allocation
Yield optimization management
Network transaction maximization
Real utility management
Systems that are used to interact with customers and run a business in real-time are called ________ systems.
tactical
strategic
operational
informational
executive
________ are the data that is deemed most important in the operation of a business.
Metadata
Master data
Reference data
Query data
Tactical data
Which of the following statements is true about an operational system?
Its primary purpose is to support managerial decision making.
It consists of historical or point-in-time data.
Its goal is to enhance ease of access and use.
It consists of narrow and simple updates and queries.
It is primarily used by managers.
Which of the following statements is true about an information system?
Its primary purpose is to run the business on a current basis.
It is primarily used by online customers, clerks, salespersons, and administrators.
It consists of narrow and simple updates and queries.
Its design goal is to enhance performance.
Its design goal is to enhance ease of access and use.
________ integrates data from various operational systems.
A data warehouse
A metadata repository
Data modeling
Master data
Data mining
The purpose of a data warehouse is to ________.
standardize the format of data retrieved from different systems
allow managers to run queries and reports themselves without having to know query languages or the structure of the underlying data
provide capabilities for discovering hidden predictive relationships in the data
put key business information into the hands of more decision makers
increase the complexity of the data to be analyzed
________ involves standardizing the format of data retrieved from different systems.
Data cleansing
Data mining
Digitizing
Content mining
Clustering
A ________ is a data warehouse that is limited in scope.
metadata repository
compound data
data model
data entity
data mart
Which of the following statements is true about a data mart?
It standardizes the format of data retrieved from different systems.
It contains selected data from a data warehouse.
It stores master data only.
It is a compilation of data from the database that is organized and produced in printed format.
It helps to eliminate data duplication.
Which of the following is NOT a type of report generated by businesses?
Scheduled report
Business report
Drill-down report
Key-indicator report
Exception report
The business processes outlined within strategic plans are often implemented as envisioned at the managerial and operational levels of the organization.
TRUE
FALSE
Data-driven organizations make decisions that can be backed up with verifiable data and are measurably more profitable than those that aren't.
TRUE
FALSE
The structure of data is typically captured in a data model.
TRUE
FALSE
Data dictionaries restrict business rules.
TRUE
FALSE
Structured Query Language is the most common language used to interface with relational database management systems (RDBMSs).
TRUE
FALSE
The primary use of online transaction processing (OLTP) systems is to define a set of reachable and exploitable vulnerabilities present in a database.
TRUE
FALSE
In a distributed online environment, performing real-time analytical processing enhances the performance of transaction processing.
TRUE
FALSE
Master data management is a management rather than a technology-focused issue.
TRUE
FALSE
Systems designed to support decision making based on stable point-in-time or historical data are called information systems.
TRUE
FALSE
Write a short note on a continuous planning process and how it is executed.
Define a database management system. What is an entity? Differentiate between records and attributes.
Explain the process of consolidating data from operational systems with other organizational data.
Select the correct statement below.
Artificial intelligence is the science of enabling humans to simulate machine thinking.
Predictive modeling helps build unexplained models.
Machine learning allows systems to learn by imitating humans.
Intelligent systems emulate and enhance human capabilities.
Intelligent agents (also called 'bots') are used by users to control how programs are opened.
________ are produced at predefined intervals to support routine decisions.
Security reports
Exception reports
Drill-down reports
Scheduled reports
Key-indicator reports
Which of the following statements is true about key-indicator reports?
They provide a summary of critical information on a recurring schedule.
They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
They are produced at predefined intervals to support routine decisions.
They highlight situations that are out of the normal range.
They answer unplanned information requests to support a non-routine decision.
Which of the following statements is true about exception reports?
They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
They are produced at predefined intervals to support routine decisions.
They answer unplanned information requests to support a non-routine decision.
They provide a summary of critical information on a recurring schedule.
They highlight situations that are out of the normal range.
________ help in analyzing why a key indicator is not at an appropriate level or why an exception occurred.
Activity reports
Exception reports
Drill-down reports
Scheduled reports
Key-indicator reports
Which of the following statements is true about ad hoc queries?
They are produced at predefined intervals to support routine decisions.
They provide a summary of critical information on a recurring schedule.
They help analyze why a key indicator is not at an appropriate level or why an exception occurred.
They answer unplanned information requests to support a non-routine decision.
They highlight situations that are out of the normal range.
________ refers to the process of quickly conducting complex, multidimensional analyses of data stored in a database that is optimized for retrieval.
Concept implementation
Online analytical processing
Compartmentalization
Data mining
Predictive analysis
Online analytical processing tools enable users to ________.
discover hidden predictive relationships in the data
find associations or correlations among sets of items
analyze different dimensions of data beyond simple data summaries
group related records together based on having similar values for attributes
extract textual information from Web documents
Which of the following statements is true about an online analytical processing server?
It is a data structure allowing for multiple dimensions to be added to a traditional two-dimensional table.
It groups related records together on the basis of having similar values for attributes.
It allows you to make hypothetical changes to the data associated with a problem and observe how these changes influence the results.
It uses reasoning methods based on knowledge about a specific problem domain in order to provide advice.
It understands how data are organized in a database and has special functions for analyzing the data.
How do online analytical processing systems improve performance?
They preaggregate data so that only the subset of the data necessary for the queries is extracted.
They use reasoning methods to outline how sensitive information will be handled, stored, transmitted, and destroyed.
They make hypothetical changes to the data associated with a problem.
They allow for multiple dimensions to be added to a traditional two-dimensional table.
They provide capabilities for discovering hidden predictive relationships in the data.
In online analytic processing systems, ________ are the values or numbers the user wants to analyze.
dimensions
forms
measures
queries
entities
In online analytical processing systems, ________ provide a way to summarize the data.
forms
measures
facts
records
dimensions
Which of the following statements is true about the online analytic processing cube?
It allows you to make hypothetical changes to the data associated with a problem and observe how these changes influence the results.
It groups related records together on the basis of having similar values for attributes.
It understands how data are organized in the database and has special functions for analyzing the data.
It is a data structure allowing for multiple dimensions to be added to a traditional two-dimensional table.
It uses reasoning methods based on knowledge about a specific problem domain in order to provide advice.
Data mining complements online analytical processing in that it ________.
finds associations or correlations among sets of items
provides capabilities for discovering hidden predictive relationships in the data
extracts textual information from Web documents
groups related records together on the basis of having similar values for attributes
analyzes different dimensions of data beyond simple data summaries
________ can be achieved by rolling up a data cube to the smallest level of aggregation needed, reducing the dimensionality, or dividing continuous measures into discrete intervals.
Data cleansing
Normalization
Clustering
Data reduction
Inferencing
Which of the following statements is true about association discovery?
It is a technique used to find correlations among sets of items.
It is the process of grouping related records together on the basis of having similar values for attributes.
It is the use of analytical techniques for extracting information from textual documents.
It is a type of intelligent system that uses reasoning methods based on knowledge about a specific problem domain in order to provide advice.
It makes sure that each table contains only attributes that are related to an entity.
________ is the process of grouping related records together based on having similar values for attributes.
Normalization
Data mining
Clustering
Inferencing
Slicing and dicing
________ refers to the use of analytical techniques for extracting information from textual documents.
Web usage mining
Text underlining
Text mining
Decision making
Web content mining
________ refers to extracting textual information from online documents.
Web usage mining
Web crawling
Text mining
Decision making
Web content mining
Which of the following is used for Web content mining?
clustering
Web underlining
neural networks
Web crawler
data reduction
________ is used by organizations to determine patterns in customers' usage data.
Web usage mining
Web crawling
Text mining
Decision making
Web content mining
Which of the following is a recording of a user's path through a Web site?
clustering
normalization
slicing and dicing
clickstream data
inferencing
________ is the ability of a page to attract and keep visitors.
Normalization
Freecycling
Stickiness
Crowdsourcing
Showrooming
Business analytics augments business intelligence by using ________ modeling to help identify trends or predict business outcomes.
refinement
threat
predictive
multivariate
decision
A(n) ________ system is a special purpose information system designed to provide assistance to organizational decision making related to a particular recurring problem.
decision support
intelligent
expert
decision generator
decision level
Which of the following analyses involves making hypothetical changes to the data associated with a problem and observing how these changes influence the results?
predictive analysis
time-series analysis
linear regression analysis
what-if analysis
multivariate analysis
________ allows using approximations or subjective values to handle situations where information about a problem is incomplete.
Fuzzy logic
Normalization
Clustering
What-if analysis
Stickiness
Which of the following statements is true about a neural network?
It allows multiple dimensions to be added to a traditional two-dimensional table.
It works in the background to provide some service when a specific event occurs.
It attempts to approximate the functioning of the human brain and can learn by example.
It uses reasoning methods based on knowledge about a specific problem domain in order to provide advice.
It helps analyze why a key indicator is not at an appropriate level or why an exception occurred.
Which of the following statements is true about user agents?
They are also known as Web spiders.
They are agents that search to find the best price for a particular product a user wishes to purchase.
They are agents that continuously analyze large data warehouses to detect changes deemed important by a user.
They are agents that automatically perform a task for a user.
They are agents designed by spammers and other Internet attackers to farm e-mail addresses off Web sites or deposit spyware on machines.
Which of the following is a role of monitoring and sensing agents?
keeping track of key data
sending a report at the first of the month automatically
assembling customized news
analyzing data warehouses to detect changes deemed important by a user
finding the best price for a particular product a user wants to purchase
Which of the following is a role of data mining agents?
tracking inventory levels
sending a report at the first of the month automatically
assembling customized news
analyzing data warehouses to detect changes deemed important by a user
finding the best price for a particular product a user wants to purchase
Which of the following statements is true about an explicit knowledge asset?
It reflects the processes and procedures that are located in a person's mind on how to effectively perform a particular task.
It reflects a person's ability to effectively solve a problem without external help.
It reflects knowledge that can be documented, archived, and codified, often with the help of information systems.
It reflects an individual's special knowledge about a new-to-the-world product.
It reflects the strategies that can be applied to an enterprise resource planning system.
Identify the primary goal for deploying a knowledge management system.
identifying how to recognize, generate, store, share, and manage tacit knowledge
presenting a view of long-term technology integration
grouping related records together on the basis of having similar values for attributes
allowing hypothetical changes to the data associated with a problem and having tacit knowledge on how these changes influence the results
linking Web sites to corporate databases to provide real-time access to personalized information
Social network analysis is a technique that attempts to ________.
analyze large data warehouses to detect changes deemed important by a user
analyze why a key indicator is not at an appropriate level or why an exception occurred
discover hidden predictive relationships in the data
allow hypothetical changes to the data associated with a problem and observe how these changes influence the results
find groups of people who work together
________ refers to the display of complex data relationships using a variety of graphical methods.
Normalization
Visualization
Clustering
Inferencing
Textual mining
Which of the following statements is true about a digital dashboard?
It is the combination of various analysis techniques and interactive visualization to solve complex problems.
It is used to support push reporting, exception reporting and alerts, and pull reporting usage models.
It can visualize features and relationships between features drawn from an underlying geographic database.
It is used to combine geographic, demographic, and other data for locating target customers.
It is a system for creating, storing, analyzing, and managing geographically referenced information.
Digital dashboards provide the decision makers with a quick overview of key performance indicators and other key operational statistics and trends. This usage model is known as ________ reporting.
exception
pull
ad hoc
drill-down
push
While using digital dashboards, pull reporting is conducted to ________.
alert the user of any items that require immediate attention
provide the decision makers with a quick overview of key performance indicators
discover hidden predictive relationships in the data
analyze the root causes of an exception
extract textual information from Web documents
The combination of various analysis techniques and interactive visualization to solve complex problems is known as ________.
security analysis
digital analysis
social network analysis
concept analytics
visual analytics
Which of the following explains the term geocoded?
Data is transformed into coordinates.
Data is shared on the Internet.
Data is used to create Web pages.
Data is compared with similar historical data.
Data is converted into soft data.
Describe online analytical processing.
Differentiate between clustering and cla
