Font size
WorksheetsK201 MIS FINAL EXAM
Total questions: 134
Worksheet time: 1hrs 7mins
in the context of computer operations, which operation best describes multiplication?
logic
retrieval
storage
arithmetic
the relative frequency of a class is computed by
dividing the midpoint of the class by the sample size
dividing the frequency of the class by the sample size
dividing the frequency of the class by the midpoint
dividing the sample size by the frequency of the class
how does the network administrator protect an organization's infrastructure?
It provides network and cybersecurity network administrator
It performs user authorization cyber police
It performs user authentication network programmer
It creates cron jobs to run automatically cyber activist
Which of the following is a risk associated with big data technology?
finding unseen patterns that can be used for forecasting and planning
monitoring of vehicles to improve fuel efficieency and delivery routes.
increase role by providing real-time analytics
privacy breaches, loss of anonymity, and discrimination.
Business _____ provides historical, current, and predictive views of business operations
intelligence
differentiation
indexing
exploration
_____ find the combination of inputs that generates the most desirable outputs
natural-language processing
speech systems
genetic algorithms
biometric systems
what're the components that SIS uses
Data, databases, process, and information data, informal information.
Data and databases alone interfacing data.
Processes and information alone prescribed information.
Data, processes, and information. Databases are still under MIS..
A computer company stores all of the customer service requests and problem resolutions in a database. This is referred to as _____, one of the 4 Rs.
react
reserve
reason
retain
income is an example of
categorical data
either categorical or quantitative
currency data
quantitative data
data collected over several time periods
time series
time controlled
cross sectional
time dependent
two popular data visualization platforms
excel and power point
apache and cassandra
oltp and olap
power bi and tableau
One of the features of Tableau is its ability to provide in-depth insights. Which of the following best demonstrates the use of that feature?
A database designer can use diagramming to visualize the final design.
A production and operation executive may use it to spot production efficiencies and meet production goals.
A marketing executive may use it to predict future sales income after a suggested price increase.
A customer may use it to compare products and negotiate a better price.
A tabular method that can be used to summarize the data on two variables simultaneously is called _____.
simultaneous equations
crosstabluation
histogram
dot plot
Which type of computing draws on the human process of drawing on accumulated experiences and feelings to make a decision:
database design
case-based reasoning
machine learning
contextual computing
data collected at the same point in time
time series
static
cross-sectional
one-dimensional
key users of a data lake are typically
data scientists
accountants
marketing managers
database administrators
A researcher is gathering data from four geographical areas designated: South = 1; North = 2; East = 3; West = 4. The designated geographical regions represent _____.
continuous data
directional data
quantitative data
categorical data
Identify the type of computer that has the highest storage capability.
subnotebooks
notebooks
personal computers
supercomputers
A new survey has been sent out to all employees in an organization. How can the HR department collect the survey results to perform an analysis?
collect survey results in a database
collect survey results in a word processor
collect survey results in a presentation software
collect survey results in a CSV document
The difference between the lower class limits of adjacent classes provides the _____.
number of classes
class limits
class midpoint
class width
In a relational database model, how can one table be cross-referenced to another table so that data can be retrieved from both tables?
the table must have primary key columns that match
the primary key column of one table must match the foreign key column of the other table
the tables must have foreign key columns that match
the tables must have the same name and primary key columns that match
line of the best fit for points in a scatter diagram
trendline
horizontal line
vertical line
fit line
In the design and implementation of any _____ reasoning application, there are 4 Rs involved: retrieve, reuse, revise, and retain.
rule based
adductive
deductive
case-based
A data _____ is a collection of data from various sources used to support decision-making applications and generate business intelligence.
dictionary
pattern
mine
warehouse
_____ is high when customers have many choices and low when they have few.
buyer power
threat of new services
rivalry among existing customers
risk of substitute products
whats the impact of the internet on small + large businesses?
can put them on equal ground with big businesses
will make them superior to big businesses
will make the big businesses superior to small businesses
will increase the demand for small business sales
_____ is the process of using procedures from statistics and computer science to extract useful information from extremely large databases.
big data
data mining
data warehousing
analytics
The term data warehousing is used to refer to the process of doing all of the following, except _____ the data.
capturing
storing
maintaining
mining
Before drawing any conclusions about the relationship between two variables shown in a crosstabulation, you should _____.
investigate whether any hidden variables could affect the conclusions
construct a scatter diagram and find the trendline
develop a relative frequency distribution
construct a pie chart for each of the variables
The average age in a sample of 90 students at City College is 20. From this sample, it can be concluded that the average age of all the students at City College _____.
must be more than 20, since the population is always larger than the sample
could be larger, smaller, or equal to 20
could not be 20
must be less than 20, since the sample is only a part of the population
the most common type of observational study is a
experiment
survey
debate
statistical inferenec
categorical data
are always nonnumeric
may either be numeric or nonnumeric
are always numeric
indicate either how much or how many
A(n) _____ is a common output device for hard copy.
optical character reader
compact disc
laser printer
plasma display
Which of the following is an example of using Power BI to improve business decision-making?
A database designer can use diagramming to visualize the final design.
A production and operation executive may use it to spot production efficiencies and meet production goals.
A marketing executive may use it to automate cold calls to potential customers.
A customer may use it to compare products and negotiate a better price.
_____ uses patterns to find solutions instead of using the if-then-else rules that expert systems use.
virtual reality simulators
artificial neural networks
turing machines
heuristic machines
Which of the following examples best illustrates the application of project management software?
an accountant builds a spreadsheet for a projet budget
a manufacturing manager creates a mailing list of all employees on a project
an architect designs a building addition for a new project
an engineering manager arranges a schedule of activities to be completed throughout a project
quantitative data
always nonnumeric
numeric or nonnumeric
always numeric
always labels
which is not a scale of measurement?
nominal
ordinal
interval
categorical
In the context of the operators used in a query by example (QBE) form, the _____ is used when only one of the conditions in the QBE form must be met.
NOT operator
AND operator
OR operator
NOR operator
the age of employees is an example of
categorical
quantitative
label data
time series
statistical inference
refers to the process of drawing inferences about the sample based on the characteristics of the populations.
the same as descriptive statistics
the process of drawing inferences about the population based on the information taken from the sample
is the same as a census
Which of the following is an example of how demographic data is explained in database marketing?
Why the buyer buys a product or service
who the buyer is
which product generated the highest sales
how buyers interact with an app
What are three criteria used to classify computers?
cost speed external storage
speed cost memory
year developed speed cost
memory storage manufacturer
Which of the following is considered a feature of Tableau?
Translating coded values, such as replacing Yes with 1
In-depth insights and "what-if" analysis
encapsulation
allocation
An organization has had an in-demand red shirt on backorder for two months. They are waiting to re-release it during the fourth quarter to raise the price for increased revenue before the end of the year. Based on Porter's Five Forces, what could happen that could destroy their plans?
A rival organization could produce the same product and make it available now.
all the buyers could create a petition to release the shirt now
all the suppliers could refuse to deliver the materials to the organization
nothing would happen. there are no alternatives for a red shirt
When the conclusions based upon the aggregated crosstabulation can be completely reversed if we look at the unaggregated data, the occurrence is known as _____.
reverse correlation
inferential statistics
simpsons paradox
disaggregation
A database company is working on a natural-language processing (NLP) system. It divides the tasks into two activities. The _____ activity involves using the computer to read large amounts of text and understanding the information well enough to summarize important points and store information so that the system can respond to inquiries about the content.
interfacing
knowledge acquisition
analysis
data warehousing
In a questionnaire, respondents are asked to record their age in years. Age is an example of a _____.
categorical variable
quantitative variable
categorical or quantitative variable, depending on how the respondents answered the question
ratio variable
A researcher asked 20 people for their zip code. The respondents zip codes are an example of _____.
categorical data
quantitative data
label data
category data
the birth weight of newborns, measured in grams, is an example of what
categorical
categorical or quantitative
neither
quantitative
Jacob, a data analyst, is working on a project from home and needs to download some data from his office network. Which of the following server platforms relate to Jacob's purpose?
remote access servers
web servers
application servers
disk servers
When the data have the properties of ordinal data and the interval between observations is expressed in terms of a fixed unit of measure, the variable has which scale of measurement?
nominal
ordinal
interval
ratio
how is data used in a data warehouse compared to its use in a database?
Data in a warehouse is typically used by the information technology staff, whereas data in a database is used by business professionals for decision-making.
Data in a data warehouse is used for transactional purposes. Database data is typically used for analytical purposes.
Data in a data warehouse is more trustworthy than data in a database.
Data in a data warehouse is used for analytical purposes. Database data is typically used transactionally.
What additional factors play a role in a customer's decision to purchase a product or service other than focus and differentiation?
cost
speed to market
market acceptance
popularity
Which of the following graphical methods is not intended for quantitative data?
stem and leaf
dot plot
scatter diagram
pie chart
_____ is a process and procedure by which knowledge is gained through experience.
data mining
forward chaining
machine learning
backward chaining
intelligent agents are also known as
loggers
bots
reactors
routers
When analyzing the segmentation of customers in database marketing, which is a variable that includes gender, age, income, and marital status?
strategic information
geographical information
psychographic information
demographic information
the data component of an information system is
the input to the information system
a series of integrated files containing relevant facts
a set of facts that the process component has analyzed
the output of the information system
There are 20 boys and 8 girls in a class. What type of graph can be used to display this information?
bar graph
stem and leaf plot
histogram
scatter diagram
The _____ component of an information system consists of raw facts and is difficult to use for making decisions.
cache
kernel
data
process
When the data have the properties of interval data and the multiplication or division of two values is meaningful, the variable has which scale of measurement?
nominal
ordinal
interval
ratio
Statistical studies in which researchers do not control variables of interest are _____.
experimental studies
uncontrolled experimental studies
not of any value
observational studies
Excel's Chart Tools does NOT have a chart type for constructing a _____.
bar chart
pie chart
histogram
stem and leaf
Categorical data can be graphically represented by using a(n) _____.
histogram
stem and leaf
scatter diagram
bar chart
In a data set, the number of observations will always be the same as the number of _____.
variables
elements
data set
data
_____ analytics encompasses the set of analytical techniques that describe what has happened in the past.
descriptive
predictive
persriptive
data
In the context of business analytics, which method prepares a decision-maker for future events?
descriptive
prescriptive
predictive
mobile analytics
A comprehensive framework called the ____ was created by Harvard Business School's Michael Porter for analyzing an organization, its position in the marketplace, and how information systems could be used to make the organization more competitive.
five forces model
six sigma model
three pyramid model
four resources model
saving a new customers name in the customer file is an example of a ________ operation
logical
retrieval
storage
arithmetic
The number of observations in a complete data set having 10 elements and 5 variables is _____.
5
10
25
50
Abstraction, inheritance, polymorphism, and encapsulation are four key principles of ________.
network attached storage
machine language
fifth generation language
object-oriented programming
transaction processing systems
involved low volumes of data
requires eextensive managerial judgement
involves repetitive operations
requires maximum human involvement
In the context of the manufacturing industry, interpret how wearable devices may provide a possible benefit in the field.
improve employee safety by providing a hands-free work environment
ability to store more data than a personal computer
storage of web pages for access over the internet
magnetic tape backup
Which type of software would be used to write a letter, check the spelling and grammar, and e-mail it to hundreds of customers?
database
spreadsheet
word processing
desktop publishing
When considering the basic tasks of computers, which of the following is considered an arithmetic operation?
saving a file to a new location
retrieving data, updating a value, and saving the updated data
comparing x to y to determine which has a larger value
subtracting 10% from a sales amount to apply a discount
In the context of computer operations, comparing two numbers is a(n) _______ operation.
arithmetic
logical
storage
retrieval
_____ is an advantage of Robotic process automation (RPA)?
increase in employment
increase in human interaction
improvement in accuracy and quality
lower start up costs
In large organizations, which of the following tasks would not be completed by a database administrator?
backup and recovery management
change management
planning for security
designing application programs
Facts and figures collected, analyzed, and summarized for presentation and interpretation are called _____.
data
variables
elements
variables and elements
a developer is designing a case-based reasoning system. when the system finally obtains a final solution, what should be done?
revise and redesign the solution
store it as a new solution
retain it as part of the library
reprogram it as part of the system
The term _____ is used to refer to the process of capturing, storing, and maintaining data.
data warehousing
data mining
data analysis
data collection
In a cumulative frequency distribution, the last class will always have a cumulative frequency equal to _____.
1
100%
the total # of elements in the data set
a value between 0 and 1
a frequency distribution is ____
tabular summary of a set of data showing the fraction of items in each of several nonoverlapping classes
graphical form of representing data
tabular summary of a set of data showing the number of items in each of several nonoverlapping classes
graphical device for presenting categorical data
How have retail businesses used RFID technology to support logistics?
to control the location of their personnel
to control the costs of goods sold
to reduce the need to stock shelves
to have better control of their supply chain and inventory management
Which best defines an operating system (OS)?
It is a set of programs for controlling and managing computer hardware and software.
It is a computer and all the software for managing network resources and offering services to a network.
It is a collection of disk drives used for fault tolerance and is typically found in large network systems.
It is the main circuit board containing connectors for attaching additional boards.
Arithmetic operations are inappropriate for _____.
categorical data
quantitative data
both categorical and quantitative
large data sets
A Scanner Data User Survey of 50 companies found that the average amount spent on scanner data per category of consumer goods was $387,325 (Mercer Management Consulting, Inc., April 24, 1997). The $387,325 is an example of _____.
categorical data
categorical variable
descriptive statistic
time series data
all data collected in a study
census
inference
variable
data set
The user interface component of an expert system provides _____ to the expert system.
user friendly access
decision support
learning
reasoning
Creating, deleting, modifying, searching, sorting, and joining data requires ______ software.
database
spreadsheet
word processing
financial/accounting
When the data are labels or names used to identify an attribute of the elements and the rank of the data is meaningful, the variable has which scale of measurement?
nominal
ordinal
interval
ratio
frequency distributions can be made for
categorical data only
quantitative data only
neither
both categorical and quantitative
the sum of the relative frequencies for all classes will always equal
the sample size
the number of classes
1
100
Categorical data use either the ______ or ______ scale of measurement.
nominal, ordinal
nominal, interval
ordinal, interval
interval, ratio
In differentiating between storage measurements, a _____ is the size of a character.
nibble
decibel
byte
node
_____ is skilled in using productivity software, such as word processors, spreadsheets, database management systems, and presentation software.
network, literacy
business literacy
information literacy
computer literacy
_____ analytics consists of analytical techniques that use models constructed from past data to predict the future or to assess the impact of one variable on another.
descriptive
predictive
prescriptive
data
the Microsoft Office package used to perform statistical analysis is
spss
word
sas
excel
In data warehouses, _____ is information about data content, quality, condition, origin, and other characteristics
metadata
big data
summary data
raw data
Which of the following is NOT an example of an existing source of data?
the internet
internal company records
US census bureau
data from an experiment
How does a database help an organization make decisions?
databases are used to create organize and manage data which can be used for strategies
databases can be used as POS transactions to improve databases' routing and delivery schedules.
databases are written for specific data applications
databases include transaction processing reports for data analysis
In a recent study based upon an inspection of 200 homes in Daisy City, 120 were found to violate one or more city codes.
The city manager released a statement that 60% of Daisy City's 3,000 homes are in violation of city codes. The manager's statement is an example of _____.
a census
an experiment
descriptive statistics
Statistical inference
The systems analyst has developed a new system for determining when a person is lying based on current and historical facial expressions the system has learned from others in the past. Which type of system is this?
data mining
forward chaining
machine learning
backward chaining
Which statement best represents assembly language.
It is more difficult than machine language to write programs for.
It uses a series of short codes, or mnemonics, to represent data or instructions.
It facilitates natural conversations between the user and the computer.
It is used primarily for Web development.
What organization developed the report, “Ethical Guidelines for Statistical Practice”?
ethic committee for statistical practices
american statistical assocation
inteernational statistical organization
federal bureau for ethical practices in statistics
A characteristic of interest for the elements is called a(n) _____.
sample
data set
variable
observation
The entities on which data are collected are _____.
elements
populations
sets
samples
Which question would best be addressed using BI (business intelligence) rather than BA (business analytics)?
how much have sales over the last three months decreased?
why has sales over the last 3 months steadily decreased?
how is thee decrease in sales affecting the overall business?
what actions should be taken to increase sales?
Quantitative data that measure "how many" are ________; quantitative data that measure "how much" are ________.
interval, ratio
ratio, interval
continuous, discrete
discrete, continuous
A small organization is proliferating, using its personnel to enter data and run manual queries for patterns. What would you recommend the business do to use the personnel better?
start using microsoft access
start using Microsoft SQL server
start using oracle
start using a temp agency to manage the data
which statement is true of big data?
it eliminates unethical actions based on interpretations.
can be efficiently processed and managed by conventional computing methods
has three dimensions: value, density, and uniformity.
the result of the exponential growth of data in both public and private organizations.
Which type of database is not limited by the data's physical location?
disitributed
relational
multi structured
semi structured
To mark technological breakthroughs in the development of computer hardware, computers are often categorized into _____.
generations
color groups
age groups
peripheral divisions
The percent frequency of a class is computed by _____.
multiplying the relative frequency by 10
dividing the relative frequency by 100
multiplying the relative frequency by 100
adding 100 to the relative frequency
Which of the following was the earliest language used on computers?
assembly language
high-level languages
machine language
compiler languages
A graphical device for presenting categorical data summaries based on subdivision of a circle into sectors that correspond to the relative frequency for each class is a _____.
histogram
stem and leaf
pie chart
bar chart
Which of the following is LEAST useful in studying the relationship between two variables?
trendline
stem and leaf
crosstabulation
scatter diagram
Which of the following is the most important web development language?
C++
html
java
visual basic
what shapes competitive strategies in an organization
competitors
partners
management information systems
strategic information systems
_____ has introduced a line of processors designed to expedite contextual computing.
qualcomm
microsoft
alyuda
When the data are labels or names used to identify an attribute of the elements, the variable has which scale of measurement?
nominal
ordinal
interval
ratio
When comparing the three basic tasks performed by computers, which of the following programs uses arithmetic operations, along with storage and retrieval?
A sales program compares the sales values from two different products and displays the larger value on the screen.
A point-of-sale program reads data keyed in by a sales representative and saves it on a hard disk.
An engineering program allows a user to key in two numbers and does a variety of different calculations with those numbers.
An accounting program reads data from a flash drive, increases the sales values by 20%, and displays them on the screen before saving them back on the flash drive.
In the context of Porter's Five Forces Model, an organization limits buyers' choices by:
encouraging the use of the Internet to gather information about products.
launching duplicate products or services in the marketplace.
offering services that make it difficult for customers to switch.
charging competitive market rates for its products or services.
A program relates to a computer in which of the following ways?
it tells the computer how to transfer data from one networked device to another
it identifies whether the computer acts as a client or a server
it establishes the correct language in which the system unit relates to peripheral devices.
it provides step by step directions for performing a specific task in a language the computer can understand
Fifteen percent of the students in a School of Business Administration are majoring in Economics, 20% in Finance, 35% in Management, and 30% in Accounting. The graphical device(s) that can be used to present these data is(are) _____.
a line graph
only a bar chart
only a pie chart
both a bar chart and a pie chart
The major applications of data mining have been made by companies with a strong _____ focus.
consumer
manufacturing
exporting
research and development
An automobile manufacturer is set to launch a well-marketed new vehicle model. This vehicle has had great reviews. Why would the manufacturer limit the number of models to the approved dealerships?
to retain supplier power
to retain buyer power
to be more cost efficient
to have product differentiation
The height and weight are recorded by the school nurse for every student in a school. What type of graph would best display the relationship between height and weight?
bar graph
stem and leaf
histogram
scatter diagram
jobs displaces by AI mostly involve
blue collar workers
health care workers
white collar workers
technical workers
In a sample of 800 students in a university, 160, or 20%, are Business majors. Based on the above information, the school's paper reported, "20% of all students at the university are Business majors." This report is an example of _____.
a sample
a population
statistical inference
descriptive statistics
A physician helps design a diagnostic expert system by providing common symptoms of gallbladder infections. This is an example of using _____.
turing machines
heuristics
quick response codes
swift codes
How do internet streaming companies like Netflix utilize data mining to their benefit?
it tailors recommendations to individual customers
it creates an additional revenue source from customers
it creates an additional revenue source by selling customer information
it tailors their shopping needs based on their watch history
the sum of frequencies for all classes will always equal
1
the number of elements in a data set
the number of classes
a value between 0 and 1
