CIS Chapter ^
Which of the following is NOT a traditional functional area of a business? a) human resources b) marketing and sales c) advertising d) supply chain management e) accounting and finance
advertising
Data is stored in a computer using patterns of _______________ defined by stranded coding schemes. a) bytes b) bits c) programming statements d) hertz c) characters
bits
_____________ typically provide(s) push reporting, exception reporting, and pull reporting. a) Web crawlers b) OLAP c) Digital dashboards d) Intelligent agents e) Neural networks
Digital dashboards
A key function of RDMBS is the ____________ , which enable users to retrieve data from the database to answer questions. a) data dictionary b) form c) table d) query e) question
Query
If your data needs exceed traditional RDBMSs and requires NoSQL, ________________ is considered a popular option. a) MySQL b) Oracle c) DB2 d) Hadoop e) SQL Server
Hadoop
To stay ahead of the competition, organizations have turned to __________ , using information systems to gather and analyze data and information from internal and external sources in order to make better business decisions. a) business applications b) business intelligence c) transaction processing d) web sites e) e-commerce
Business Intelligence
An example of a type of unstructured data is: a) customer comments on a social media site b) click stream data from a website c) sensor readings d) spreadsheets e) transaction data
Customer comments posted on social media site
The purpose of a(n) __________ is to store and distribute valuable data from an organization's internal information systems and external sources for analysis and querying. a) operational system b) transaction processing system c) data warehouse d) master file e) data dictionary
Data Warehouse
Which of the following statements about data marts is NOT true? a) data marts are considerably more expensive to develop than data warehouse b) a data mart is a smaller-scope data warehouse c) data marts can be targeted to a specific group of end users d) data marts are often found in small and medium-sized businesses e) data marts can be implemented on simpler and less expensive hardware compared to data warehouse
Data marts are considerably more expensive to develop than data warehouses
A ____________ is a software application with which you create, store, organize, and retrieve data from a single database or several databases. a) file b) network c) transaction d) application program e) database management system
Database Management System
A(n) __________ is something you collect data about. a) table b) row c) column d) record e) entity
Entity
The __________ database management system is capable of handling large volumes of unstructured data. a) file-based b) client-based c) MySQL d) RDBMS e) NoSQL
NoSQL
A key consideration related to business intelligence (BI) is that focuses on _________ data to aid in decision making. a) redundant b) future c) aligned d) predictive e) past
Past
Which of the following is a limitation of relational database management systems (RDBMS)? a)RDBMS data are stored in tables b) RDBMS allow for different data types c) RDBMS are not easily scalable in response to demand variations d) RDBMS allows for inserting data e) RDBMS support business processes
RDBMS are not easily scalable in response to demand variations
______________ is an example of volatile memory. a) Random access memory (RAM) b) an optical disk c) Read-only memory d) a redundant array of independent drives (RAID) e) a solid-state drive
Random access memory (RAM)
A(n) ___________ is also known as an entity instance. a) record b) attribute c) table d) column e) cell
Record
Which of the following is an important enabling technology that is used to share similar data across applications over the Web? a) SQL b) HTML c) XML d) ISM e) URL
XML
The purpose of an OLAP cube is to: a) record a sales transaction b) allow data to be analyzed on a single dimension c) allow data to be analyzed by multiple dimensions d) analyze an expert's judgement e) facilitate e-commerce
allow data to be analyzed by multiple dimensions
___________________ CRM systems include technologies such as data mining, decision support, and other business intelligence capabilities. a) analytical b) communicational c) executive d) collaborative e) operational
analytical
The type of data mining that is used to identify items that are frequently purchased together is called _________ discovery. a) predictive b) association c) sequence d) class e) intersection
association
Most enterprise software is built around a set of ________, which reflect techniques and processes that have consistently shown superior results. a) operational guidelines b) best practices c) accreditation standards d) functional guidelines e) predictable routines
best practices
The type of testing that involves actual system users performing tests of the new system with actual data is called ___________ testing. a) alpha b) beta c) developmental d) performance e) usability
beta
A ___________ analysis is used to determine when the costs of a new training program are equal to the benefits to the organization. a) break-even b) risk-assessment c) net present value d) systems e) weighted multicriteria
break-even
An integrated supply network can help reduce the impact of the ___________, which occurs when small forecasting errors at the end of the supply chain produce massive forecasting errors farther up in the supply chain. a) forecast error result b) saturation effect c) bullwhip effect d) fluctuation effect e) demand swing effect
bullwhip effect
Amazon.com works with another commercial vendor to set up a web-based procurement system. Which of the following terms best describes this situation? a) Value chain management b) Business-to-business electronic commerce c) Supplier-to-supplier electronic commerce d) Electronic data interchange e) Supplier-to-business electronic commerce
business-to-business electronic commerce
Operating systems perform a variety of necessary functions for computers, including all of the following EXCEPT: a) maintaining the structure of storage directories and sub-directories b) changing the font style and color in a Word document c) booting (starting) the computer d) managing the programs and data in main memory e) managing secondary storage
changing the font style and color in a Word document
The purpose of online analytical processing (OLAP) is to provide: a)complex multidimensional data analyses b) expert decision making c) predictive forecasts d) simple data summaries e) rapid posting of transaction data
complex multidimensional data analyses
To successfully implement CRM, organizations will have to implement all of the following organizational changes EXCEPT: a) policies and processes must reflect a customer focus b) measures of the customer experience must be monitored and shared c) employees must be trained to have a customer focus d) measures for customer satisfaction must be monitored e) concerns about customer privacy can be relaxed
concern about customer privacy can be relaxed
An activity that is critical in the implementation of an ERP system but is often underestimated is that of _________. a) connecting the network b) customizing the user interface c) installing the software on the hardware d) configuring the ERP system parameters e) selecting the color of the fonts and screen background
configuring the ERP system parameters
Today, organizations require a(n) _____________ in order to monitor and analyze data and business processes, adjust business process, and update organizational plans. a) random planning cycle b) annual strategic plan c) budget plan d) separate company e) continuous planning process
continuous planning process
The purpose of a(n) _____________ is to support the communication preferences of customers, using multiple communication channels. a) digital dashboard b) customer engagement center c) enterprise marketing management system d) customer service center e) sales force automation system
customer engagement center
An organization that uses an access point that automates the business processes that occur before, during, and after sales have been transacted between itself and multiple customers is using a _________________. a) customer exchange system b) sourcing portal c) procurement portal d) supplier portal e) customer portal
customer portal
Core components of ERP systems include all of the following EXCEPT: a) inbound logistics b) customer relationship management c) sales and marketing d) employee recruitment e) financial reporting
customer relationship management
The core business process that focuses on after-sale activities is: a) customer service b) receiving and stocking raw materials, parts, and products c) order processing d) sales of end products e) distribution of end products
customer service
Which of the following is the component of the operational CRM that automates service requests, complaints, product returns, and information requests? a) digital dashboard b) customer engagement c) customer service d) enterprise marketing management e) sales force automation system
customer service
When a company has a unique software need that cannot be satisfied by generic technologies, it will usually choose a(n) ____________ software option. a) generic b) embedded c) personal productivity d) customized e) off-the-shelf
customized
___________ algorithms search for hidden patterns in large volumes of data in order to develop predictive models. a) data mining b) OLAP c) RDBMS d) E-commerce e) OLTP
data mining
which of the following statements about the relational database model is NOT true? a) tables can be related through the use of common fields b) data redundancy is completely eliminated c) records of data are in table rows d) tables contain all the facts about the objects of interests in the database e) fields of data in table columns
data redundancy is completely eliminated
What is the purpose of making a business case for an information system? a) define the value expected from the investment in the system b) define what the organization needs from the new system c) define the approach to take in acquiring the information system d) define the legal requirements of the new system e) define the hardware infrastructure that will support the new system
define the value expected from the investment in the system
Which of the following helps visualize key CRM performance metrics? a) digital dashboard b) customer portal c) XML tag d) XBRL data e) transaction processing system
digital dashboard
The outbound logistics core activity is associated with: a) receiving and stocking raw materials, parts, and products b) distribution of end products c) manufacturing of end products d) selling of end products to customers e) order processing
distribution of end products
A company whose supply chain is focused on maximizing customer service is striving to achieve supply chain ______________. a) balance b) equilibrium c) effectiveness d) equality e) efficiency
effectiveness
Which of the following terms refers to computer-to-computer communication following specific standards? a) interchange data protocol (IDP) b) Transaction data exchange (TDE) c) electronic data transfer (EDT) d) transaction data transfer (TDT) e) electronic data interchange (EDI)
electronic data interchange (EDI)
In an effort to correct the problems associated with standalone systems, organizations have turned to _______________ systems. a) primary b) enterprise-wide systems c) core d) support e) legacy
enterprise-wide systems
which of the following is commonly used when designing a database for the purpose of showing associations between entities? a) entity normalization technique b) packet switching c) computer clustering d) batch processing e) entity-relationship diagram
entity-relationship diagram
A(n) ___________ system uses reasoning methods based on knowledge about a specific problem domain in order to provide advice. a) data mining b) OLAP c) competitive intelligence d) expert e) decision support
expert
The three types of arguments typically made in the business case for an information system are ________. a) faith, fear, and facts b) costs, benefits, and facts c) fear, benefits, and competition d) faith, data, and profits e) facts, fear, and costs
faith, fear, and facts
The business case for a new information system includes this argument: "We must have this new system to keep up with our competition." This is an example of a _________-based argument. a) profit b) fear c) benefit d) fact e) faith
fear
A company that implements CRM software and strategy can expect all of the following benefits EXCEPT: a) better information b) faster problem identification and resolution c) higher customer turnover d) individualized service e) improved product development
higher customer turnover
"Making the business case" is best defined as ________ the value provided by a system. a) identifying and limiting b) describing c) identifying, quantifying, and presenting d) describing and presenting e) limiting and presenting
identifying, quantifying, and presenting
When companies deploy supply chain management systems, they are hoping to experience all of the following benefits EXCEPT: a) improved customer service b) accelerated product development and innovation c) improved coordination of suppliers d) increased time to market e) reduced inventory costs
increased time to market
The support activity that ensures that employees have the hardware, software, and network access required to perform their jobs is ________. a) procurement activities b) human resources activities c) infrastructure activities d) administrative activities e) technology development activities
infrastructure activities
An information system that supports functional areas, business processes, and decision making within an organization is ________________. a) customer focused b) enterprise focused c) stakeholder- focused d) supplier-focused e) internally focuses
internally focused
Standalone systems that cannot integrate with other systems easily are generally called _____________ systems, and are frequently on the list of systems that need to be replaced. a) legacy b) support c) integrated d) enterprise e) primary
legacy
Collaborative CRM provides all of the following customer communication enhancements EXCEPT: a) reduced communication barriers b) better customer service from any touch point c) better understanding of customer history d) less customer interaction with the company e) better understanding of customer current needs
less customer interaction with the company
The core business process in which goods are not manufactured until a sales order is actually received is called ________________. a) make-to-order b) market-to-stock c) value chain d) order-to-cash e) procure-to-pay
market-to-order
Using a decision support system to determine market share is a(n) __________ function. a) accounting b) marketing c) finance d) production e) human resources
marketing
All of the following are important recommendations to achieve a successful enterprise system implementation EXCEPT: a) secure executive sponsorship b) get help for outside experts c) involve the right people d) minimize the time devoted to training e) look beyond ERP
minimize the time devoted to training
When the system fails to improve productivity because of poor design and implementation, the cause is often _______________________. a) intangible costs b) measurement problems c) mismanagement d) time lags e) redistribution
mismanagement
If the organization fails to include the right people in an enterprise system implementation project, all of the following problems may occur EXCEPT: a) people may refuse to use the new system b) essential business requirements may be overlooked c) people may react negatively to the new system d) different perspectives will not be captured e) money can be saved with a faster implementation
money can be saved with a faster implementation
The advantages of the just-in-time production strategies include all of the following EXCEPT: a) risks to inventory obsolescence are reduced b) more frequent missed production schedules c) parts and raw materials arrive just when they are needed for production d) capital costs of inventory are minimized e) inventory storage costs are minimized
more frequent missed production schedules
The technique of ___________ is necessary to refine the structure of a relational database model to optimize its efficiency and maintainability. a) fine-tuning b) refinement c) renovation d) enhancement e) normalization
normalization
Software, such as Microsoft Office, that is written by third-party vendors for the needs of different users and organizations is known as ________software. a) off-the-shelf b) business process c) network d) custom e) open source
off-the-shelf
When purchasing goods from Amazon.com, which of the following terms refers to the process of creating an account, adding items to the shopping cart, providing billing and shipping information, and submitting the order? a) enterprise system management b) make-to-order process c) make-to-stock process d) inbound logistics e) order-to-cash process
order-to-cash process
Which of the following is NOT a challenge associated with creating an effective supply chain management strategy? a) overcome concerns about intellectual property theft b) the system is only as good as the data it receives c) overcome distrust among supply chains partners d) gain agreement among supply chain partners on the supply chain management system to use e) overcome database normalization challenges with relational databases
overcome database normalization challenges with relational databases
The phases of the systems development life cycle (SDLC), in order, are: a) design; planning and selection; implementation and operation b) analysis; design; planning and selection c) design; analysis; planning and selection; implementation and operations d) planning and selection; analysis; design; implementation and operation e) analysis; planning and selection; implementation and operation
planning and selection; analysis; design; implementation and operation
The purpose of a(n) ______________ is to connect other devices to a computer. a) port b) tape c) element d) portal e) power supply
port
A(n) _______________ key, like StudentID in a STUDENT table, is used to uniquely identify each row or record in a database table. a) optional b) primary c) foreign d) redundant e) relationship
primary
Amazon.com works with external vendors in order to offer vast amounts of products. Which of the following terms refers to the process of obtaining goods from these vendors? a) make-to-order process b) make-to-stock process c) order-to-cash process d) value chain procurement e) procure-to-pay process
procure-to-pay process
Which of the following terms refers to the difficulty of showing that information system investments generate significant productivity gains? a) inverted cost curve b) productivity paradox c) proxy variability d) tangible cost phenomenon c) statistical anomaly
productive paradox
which of the following is NOT a key purpose of business analytics? a) provide a detailed picture of the current state of a business b) identify trends c) predict business outcomes d) understand the data e) build explanatory models
provide a detailed picture of the current state of a business
The purpose of a key indicator report is to: a) provide answers to unplanned questions b) provide access to greater levels of detail c) provide a summary of critical information on a regular schedule d) provide routine information at predefined intervals e) highlight situations that fall outside the expected normal range of values
provide a summary of critical information on a regular schedule
The core activity of inbound logistics involves: a) distribution of end products b) receiving and stocking raw materials, parts, and products c) manufacturing of end products d) selling of end products to customers e) order processing
receiving and stocking raw materials, parts, and products.
When examining overall IS productivity in an industry, ______________ occurs when benefits are difficult to identify because innovations may be beneficial for individual firms, but not the industry as a whole. a) measurement b) competition c) mismanagement d) redistribution e) lag times
redistribution
Which of the following is NOT a common purpose of a geographic information system? a) locate target customers b) identify optimal product mixes at a specific locations c) perform competitor analysis d) replicate an expert's judgement e) find optimal site locations
replicate an expert's judgement
A critical task in the systems analysis phase of the SDLC is _________________. a) estimating tangible benefits b) usability testing c) estimating tangible costs d) requirements collection e) human-computer interaction design
requirements collection
Which of the following is the component of the operational CRM that supports the day-to-day sales activities of an organization? a) customer engagement b) customer service c) digital dashboards d) sales force automation e) enterprise marketing management
sales force automation
A key distinction between the business processes of manufacturing businesses versus service businesses is: a) service business do not deal with products whereas manufacturing business do b) service business do not require the sales and marketing core business process c) service business do not require much emphasis on inbound and outbound logistics core business processes d) manufacturing businesses do not require the customer service core business process e) neither type of business requires the human resources core business process
service business do not require much emphasis on inbound and outbound logistics core business processes
Which of the following involves creating formal groups to identify and assess the volume and sentiment of what is being said about a company, individual, product, or brand? a) web content mining b) predictive CRM c) competitive intelligence d) Mobile CRM e) social media monitoring
social media monitoring
Systems that have been created to support the processing needs of particular business activities in particular departments are termed ___________ applications. a) standalone b) support c) primary d) enterprise e) integrates
standalone
A ______ automates the business processes involved in purchasing or procuring products between a single buyer and multiple suppliers. a) vendor exchange b) customer portal c) market portal d) sourcing array e) supplier portal
supplier portal
A _______ refers to a collection of companies and processes involved in moving a product from the suppliers of raw materials and parts to final production, and to the customer. a) supply chain b) value chain c) portal d) production chain e) production line
supply chain
___________ applications are part of an interorganizational information system that facilitates the upstream flow of information. a) customer relationship management b) supply chain management c) decision support d) executive support e) management information
supply chain management
When organizations use components of the supply chain management system to work with partners across the supply network to improve accuracy of demand forecasts, reduce inventory buffers, increase the velocity of materials, and improve customer service, they are using the ____________ function. a) safety stock planning b) supply network collaboration c) materials management d) distribution planning e) order promising
supply network collaboration
Which of the following is NOT a basic step of business process management? a) surveying customers about product preferences b) developing a vision that specifies business objectives c) understanding and measuring existing processes d) identifying ways to improve processes with information systems e) identifying critical processes to be redesigned
surveying customers about product preferences
The ________________ has primary responsibility in a systems development project. a) infrastructure analyst b) database analyst c) systems analyst d) network administrator e) data scientist
system analyst
Which of the following is a process that a company like Netflix would use to develop, build, and maintain a system to improve movie recommendations? a) systems analysis and design b) break-even analysis c) risk analysis d) weighted multi criteria analysis e) net present value analysis
systems analysis and design
A key challenge of knowledge management systems is to identify and manage ___________ knowledge assets and make them available to organizations members. a) explicit b) archival c) private d) tacit e) textual
tacit
Features of an ERP system include all of the following EXCEPT: a) consistent look and feel b) centralized storage of data c) enhanced organization-wide access to data d) complaint with regulatory requirements e) tailored to each organization's unique business needs
tailored to each organization's unique business needs
Organizations that build Internet, intranet, extranet, or mobile applications are utilizing the ______________ support business activity. a) infrastructure b) technology development c) human resources d) administrative e) procurement
technology development
Reasons why radio-frequency identification (RFID) tags are becoming a very popular technology in supply chain management systems include all of the following EXCEPT: a) the need for hand-scanning is eliminated b) the tags are much cheaper than bare codes c) the need for line-of-sight reading is eliminated d) information on the tags can be easily modified e) more information can be stored on the tag circuits
the tags are much cheaper than bar codes
The financial analysis associated with investing in a new information system should include ______________________, which includes all acquisition, use, and maintenance costs. a) the total cost of ownership b) recurring costs c) intangible benefits d) intangible costs e) both intangible costs and benefits
the total cost of ownership
________________ is(are) sometimes attributed for productivity challenges related to the time when an organization makes an investment until benefits are actually realized. a) assets b) liabilities c) time cycles d) time lags e) downtime
time lags
Company A is a supplier to company B and provides information through its value chain to its customer (company B). Company B is a supplier to company C and provides information through its value chain to its customer (company C). Connecting the value chains so that information flows between companies creates a ________ system. a) enterprise b) unified c) intranet d) value e) structural
value
The set of business activities that add value to the end product is referred to as a __________. a) value chain b) critical path c) essential structure d) primary flow e) key sequence
value chain
When Walmart enables a supplier such as Proctor & Gamble to manage the inventory levels of P&G goods in Walmart warehouses by sharing inventory and sales data, it is using the ______________ business model. a) vertical inventory management b) just-in-time c) remote inventory management d) vendor-managed inventory e) supplier-sourced inventory
vendor-managed inventory
A market comprised of firms operating within a certain industry sector is termed a _____________ market. a) captive b) vertical c) horizontal d) stable e) non-competitive
vertical
Which of the following is NOT a key process generally supported by supply chain planning modules? a) distribution planning b) demand planning and forecasting c) warehouse layout planning d) production planning e) inventory and safety stock planning
warehouse layout planning
The _____________ is used to decide which of several different IS investments is the most desirable for the organization to accept. a) discount rate b) weighted multi criteria analysis c) internal rate of return d) break-even point e) cost-benefit analysis
weighted multi criteria analysis
A common feature of a decision support system (DSS) is to perform ___________ to examine alternative problem solutions. a) web content mining b) competitive intelligence c) what-if analysis d) correlation analysis e) association discovery
what-if analysis
