Exam 1 - AND, OR, and NOT are called Boolean operators Complete Solution
1.
AND, OR, and NOT are called Boolean operators and they can be used to
... [Show More] improve the quality of a query. Which of the following is NOT true?
A) NOT is a filter that narrows a search as it excludes any item containing a specific search term within it.
B) OR can broaden a search.
C) AND links similar concepts or ideas.
D) All three terms represent logical connections in a query.
Feedback: Using AND will narrow a search. The more words or phrases connected by AND the fewer and more specific results retrieved. AND links different con¬cepts or ideas. Using OR will broaden a search. OR links similar concepts or ideas. NOT narrows a search as it excludes any item containing that specific search term within it. AND, OR, and NOT are called Boolean operators and they represent logical connections in a query. AND is exclusionary (only those entries that match both sides of the operator are true); OR is inclusive (entries that match one or both sides of the operator are returned); and NOT is a filter that refines results by excluding results that match a particular term.
Table for Individual Question Feedback
Points Earned: 0.0/1.0
Correct Answer(s): C
2.
A firm that purchases a commercial-off-the-shelf (COTS) information system benefits in getting a standardized system without having to absorb development costs but risks getting a system that does not align with the firm's businesses processes and existing technologies.
A) True
B) False
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): True
3.
Individuals who have an interest in the outcome of a system development project are called __________________.
A) owners
B) stakeholders
C) users
D) partners
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): B
4.
The relationship of multiple data points is called information.
A) True
B) False
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): True
5.
A good requirement is one that is both specific and measurable.
A) True
B) False
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): True
6.
Getting buy-in from top management or having a senior-manager act as a project champion are two ways of effectively managing stakeholders.
A) True
B) False
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): True
7.
A piece of software that is used to perform a specific task is called an ______________.
A) application
B) BIOS
C) firmware
D) operating system
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): A
8.
Match the terms to their definitions.
A. Customer Relationship Management (CRM) system
B. Business Intelligence (BI) system
C. Supply-chain Management (SCM) system
D. Database Management system (DBMS)
used to support sales and marketing activities
used for creating, maintaining and manipulating data
used to manage the flow of raw materials into the firm, and finished products and services to the point of consumption
used to support organizational decision-making through analysis and reporting
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): Business Intelligence (BI) system:used to support organizational decision-making through analysis and reporting, Supply-chain Management (SCM) system:used to manage the flow of raw materials into the firm, and finished products and services to the point of consumption, Database Management system (DBMS):used for creating, maintaining and manipulating data, Customer Relationship Management (CRM) system:used to support sales and marketing activities
9.
A formula can refer to cells in other EXCEL worksheets.
A) True
B) False
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): True
10.
What model of system development is pictured below?
A) Prototyping
B) System Development Lifecycle
C) Agile Programming
D) Rapid Application Deployment
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): B
11.
A project charter is an example of a _________________ tool available to project managers.
A) process management
B) stakeholder management
C) progress management
D) risk management
Feedback: A project charter is a process management tool. Process management is critical to tracking the operation of the project.
Table for Individual Question Feedback
Points Earned: 0.0/1.0
Correct Answer(s): A
12.
The study How Much Information estimated that Americans produced how much information in 2003?
A) 14,000 Exabytes
B) 140 Megabytes
C) 1,400 Terabytes
D) 14 Gigabytes
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): C
13.
When a firm is consistently more profitable than its competitors, it has achieved:
A) market dominance
B) sustainable competitive advantage
C) hyper-efficiency
D) operational effectiveness
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): B
14.
In the graphic below, what EXCEL fomula is used to calculate the values in the INTEREST column?
A) IPMT()
B) PPMT()
C) IRR()
D) PMT()
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): A
15.
You cannot name cells and then refer to those cell names in formulas.
A) True
B) False
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): False
16.
In the graphic below, what formula is used to calculate values in the PRINCIPAL column?
A) =IRR()
B) =PMT()
C) =IPMT()
D) =PPMT()
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): D
17.
In EXCEL, formulas like NPV(), IPMT(), and IRR() can be found in what group on the Formulas tab?
A) Lookup & Reference
B) Logical
C) Math & Trig
D) Financials
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): D
18.
An EXCEL file is called a __________, and the workspace in an EXCEL file is called a ___________.
A) spreadsheet, workbook
B) worksheet, workbook
C) workbook, worksheet
D) worksheet, spreadsheet
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): C
19.
The feature in EXCEL that allows you to create a summary table without having to enter the formulas yourself is called a:
A) worksheet
B) display table
C) summary table
D) pivot table
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): D
20.
A storyboard is an example of a ______________ prototype.
A) low-fidelity
B) high-fidelity
C) iterative
D) direct
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): A
21.
The resource-based view of competitive advantage states that for something to yield competitive advantage it must be:
A) rare, hard to duplicate, and non-substitutable
B) timely, accurate, and accessible
C) efficient, cost-effective, and replicable
D) different, superior, and scalable
Table for Individual Question Feedback
Points Earned: 0.0/1.0
Correct Answer(s): A
22.
iOS, Android, and Linux are all examples of what type of software?
A) operating system
B) desktop
C) server
D) application
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): A
23.
High switching costs are one of the ways a firm can maintain strategic competitive advantage because they act as a barrier to entry for competitors.
A) True
B) False
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): True
24.
The keyboard, mouse, and computer desktop (example pictured below) are all components that make up the:
A) operating system
B) user interface
C) hardware
D) software
Table for Individual Question Feedback
Points Earned: 0.0/1.0
Correct Answer(s): B
25.
____________ software is implemented in modules to automate the entire value chain.
A) Supply-chain management
B) Knowledge management
C) Enterprise resource planning
D) Business intelligence
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): C
26.
The set of activities through which a product or service is created and brought to market is called a ______________.
A) manufacturing process
B) distribution channel
C) value chain
D) supply chain
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): C
27.
A form of computing where systems in different location communicate and collaborate to complete a task is called ___________.
A) distributed computing
B) cloud computing
C) client-server computing
D) web services computing
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): A
28.
A ______________ is a system that uses data from other systems to do reporting and analysis.
A) supply-chain management
B) business intelligence
C) enterprise resource planning
D) transaction processing
Table for Individual Question Feedback
Points Earned: 0.0/1.0
Correct Answer(s): B
29.
___________________ exist when consumers incur an expense to move from one product or service to another.
A) Switching costs
B) Competitive advantages
C) Network effects
D) Transactional costs
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): A
30.
Metcalfe's Law which states that the value of a product or service increases as its number of users expands describes what phenomenon?
A) Transactional costs
B) Competitive advantages
C) Switching costs
D) Network effects
Table for Individual Question Feedback
Points Earned: 1.0/1.0
Correct Answer(s): D [Show Less]