Quizzes Flashcards

(56 cards)

1
Q

The technical term for a row in a relational database table is a/an:

A

Tuple

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The process of mining text from e-mail messages, blogs, and social media in
order to detect favorable or unfavorable opinions about specific subjects is
called ________

A

Sentiment analysis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which of the following would you use to consolidate the relevant knowledge
and experience in the firm and make it available to improve business
processes and management decision making

A

Knowledge Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

When Google unveiled its Google+ social network to compete with the
already established Facebook, it failed miserably. Which of the following
might help explain why Google+ was failed

A

Metcalfe’s Law and Network Economics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A(n) ________ system centralizes data from various key business processes
and stores the data in a single, comprehensive data repository, and usable by
all units of the organization

A

Enterprise system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

In a DBMS the _____ presents the data as they would be perceived by end
users, whereas the _______ shows how data are actually organized and
structured on the computer’s storage media

A

logical view, physical view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

One of the best methods developed to measure the success of an ERP system in an
organization is the balanced scorecard method. The balanced scorecard method views the
organization from different perspectives and users should develop metrics, collect data,
and analyze their business relative to each of these perspectives. Which one of the
following is not among the perspectives?

A

The supplier perspective

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Balanced Scorecard main perspectives:

A
  1. The learning and growth perspective
  2. The internal business process perspective
  3. The financial perspective
  4. The customer perspective
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following is NOT correct?
a) Blockchain is a distributed ledger system
b) Complementary assets mainly concern technology investments
c) CRM systems provide a single point for users to manage and
evaluate marketing campaigns across multiple channels
d) Global Supply Chains are typically more complex
e) An operating system manages multiprogramming

A

b) Complementary assets mainly concern technology investments

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which of the following might be reasons why firms may seek the help of Consulting
and System Integration Service Companies
a) Even large firms do not have resources for full range of support for new, complex
infrastructure
b) Integrating new Infrastructure with legacy systems continues to be a major
concern for many firms
c) Contracting outside companies is always cheaper than trying to do things in-house
d) A) and B)
e) All of the above

A

A) and B)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

All of the following statements are true EXCEPT:
a) A foreign key is used to link tables in a relational database.
b) A primary key is made of exactly one field.
c) A foreign key in one table is a primary key in another table.
d) A primary key must have a unique value for each record in the table.
e) Each table must have at least one key field.

A

b) A primary key is made of exactly one field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which one of the following is not a part of a typical business
intelligence environment?
a) Business Data
b) Business intelligence infrastructure
c) Managerial users and methods
d) Data Centre
e) User Interface

A

d) data centre

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

In our organization, we need users to obtain online answers to ad-hoc
questions in a rapid amount of time. Which one of the following tools will be
helpful?

A

a) OLAP (Online Analytical Processing)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

As a sales manager, it is your responsibility to track sales of your company’s
products. You notice that your sales numbers are down. Defining the problem
is something you do in which stage of the decision-making process?

A

a) intelligence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following is an example of an organizational
complementary asset?
a) An efficient database
b) A collaborative work environment
c) Laws and regulations
d) Strong senior management
e) Efficient business processes

A

b) A collaborative work environment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

All of the following describe the effects of globalization except:
a) significant decreases in operating costs.
b) increased ability to find low-cost suppliers.
c) ability to reliably obtain price and quality information
worldwide.
d) increases in transaction costs.
e) ability of firms to replicate their business models in multiple
countries without having to redesign expensive fixed-cost
information systems infrastructure.

A

d) increases in transaction costs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Raw data collected at checkout counters in a grocery store
is an example of

A

input

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Walmart exemplifies the power of information systems
coupled with state-of-the-art business practices and
supportive management to achieve which of the following?

A

Competitive advantage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

If sales of your products declined in a specific region of the
country, which of the following types of system would best help
discover that?

A

b) Management information systems (MIS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which of the following is an example of a cross-functional
business process?

A

d) Launching a new product

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Which type of information system would you use to forecast the
return on investment if your firm planned to switch to a new
supplier that offered products at a lower cost?

A

c) decision support systems

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

During which era were we finally able to share data between
computers separated by large geographical distances?

A

a) cloud and mobile computing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

You have been asked to implement enterprise software for a
manufacturer of kitchen appliances. What is the first step you should
take?

A

Select the functions of the system you wish to use.

24
Q

Which common database challenge is illustrated by a person
receiving multiple copies of an L.L. Bean catalog, each
addressed to a slightly different variation of his or her full
name?

A

Data inconsistency

25
The ________ phase of decision making involves identifying and exploring various solutions to a problem
design
26
The 5 phases of the decision making process
1. Intelligence phase 2. Design phase 3. Choice phase 4. Implementation phase 5. Analysis phase
27
What is the intelligence phase
identify and define the problem
28
What is the design phase
generating and evaluating potential solutions or alternatives
29
What is the choice phase
you select the best alternative from the options generated during the design phase
30
What is the implementation phase
putting the selected solution into action
31
What is the analysis phase
assessing the outcomes of the decision after implementation
32
Which type of infrastructure service stores and manages corporate data and provides capabilities for analyzing the data?
Data management
33
Implementing an HIS at a hospital will allow medical professionals to spend more time with patients because:
Workflows are completed in one system instead of multiple disconnected systems
34
Which of the following is a reason why an enterprise system in a hospital can take many months or years to implement?
Individuals and departments within the hospital will resist change. The time required for training and preparing hospital staff can be significant. More time is required to ensure high-quality data are available within the system.
35
What does a hospital information system provide?
Consistent information and processes that can be used throughout the entire hospital
36
The following components are part of the IT Infrastructure Ecosystem:
Operating Systems and Ordinary Systems (OS) Consultants and IT executives Big Data Management and Social Media Platforms Computer hardware and enterprise software
37
TCP/IP is...
Communication protocols allowing computers to connect together using the Internet
38
The value of an efficient SCM is the following:
Lower costs through efficient management of the supply chain, reducing inventory costs at each stage of the chain
39
An SCM can become very complex for the following reasons:
Transportation can be complex with different modes, such as ships and rail Some items are critical and must be delivered rapidly and can never be out of stock A buying organization, that receives the supplies, may have many locations and require parts from many suppliers Many suppliers from locations around the world may participate in the supply chain
40
SAP is a global provider of SCM software. Select the one following statement that is true.
SCM is one of the modules of enterprise software that SAP sells, others include CRM and ERP modules.
41
The benefits of an SCM are:
Coordination of information through an enterprise system to improve supply chain efficiency.
42
SCM is an enterprise system that:
Maximises total supply chain effectiveness Links one or more suppliers with the organization that purchases from those suppliers Manages information flows between activities in the supply chain Improves corporate profitability
43
Distribution and delivery of products to retailers is part of the:
downstream portion of the supply chain
44
You are creating a database to store temperature and wind data from various airports. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?
Airport Code
45
A common field that links two different tables and serves as a primary key to one of these tables is called the:
foreign key
46
You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use the data mining software you are using to do which of the following?
Identify clusters
47
A characteristic or quality that describes a particular database entity is called a(n):
attribute
48
A(n) ________ represent data as two-dimensional tables.
relational DBMS
49
Data ________ occurs when the same data is duplicated in multiple files of a database.
redundancy
50
Data mining allows users to:
find hidden relationships in large databases
51
Which of the following occurs when the same attribute in related data files has different values?
Data inconsistency
52
A household appliances manufacturer has hired you to help analyze its social media data sets to determine which of its refrigerators are seen as the most reliable. Which of the following tools would you use to analyze this data?
Sentiment analysis software
53
Which type of decision is deciding whether to introduce a new product line?
Unstructured
54
The ________ phase of decision making involves identifying and exploring various solutions to a problem
design
55
Establishing a firm's long-term goals is an example of a(n) ________ decision
unstructured
56
Which of the following is not one of the six main elements in the business intelligence environment discussed in this chapter?
Organizational culture