CIS 2200 Final

question

Place the following members of the data hierarchy in their correct order
answer

d) Bit – byte – field – record – file – database
question

In the data hierarchy, the smallest element is the _____
answer

Bit
question

A(n) _____ is a logical grouping of characters into a word, a small group of words, or a complete number
answer

Field
question

A(n) _____ is a logical grouping of related fields
answer

record
question

A(n) _____ is a logical grouping of related records
answer

file
question

A(n) _____ represents a single character, such as a letter, number, or symbol
answer

Byte
question

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.
answer

secondary keys
question

In a database, the primary key field is used to _____
answer

uniquely identify a record
question

As an individual student in your university’s student database, you are a(n) _____ of the STUDENT class
answer

instance
question

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?
answer

many-to-many
question

In a university’s relational database, the student record contains information regarding the student’s last name. The last name is a(n):
answer

attribute
question

Data dictionaries perform all of the following functions except:
answer

Providing information on each record.
question

Data dictionaries provide which of the following advantages to the organization?
answer

all of these
question

The data in a data warehouse have which of the following characteristics?
answer

They are organized by subject.
question

The data in a data warehouse:
answer

are not updated
question

The process of moving data from various sources into the data warehouse is called:
answer

extracting, transforming, and loading
question

Compared to data warehouses, data marts have which one of the following characteristics?
answer

they cost less
question

_____ is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that are part of the organization’s memory and typically reside inside the organization in an unstructured manner.
answer

knowledge management
question

_____ can be exercised to solve a problem, whereas _____ may or may not be able to be exercised to solve a problem.
answer

knowledge, information
question

Explicit knowledge has which of the following characteristics?
answer

objective
question

Tacit knowledge has which of the following characteristics?
answer

unstructured
question

Historically, management information systems have focused on capturing, storing, managing, and reporting _____ knowledge.
answer

explicit
question

The most important benefit of knowledge management systems is:
answer

They make best practices available to employees.
question

_____ is the process by which organizational goals are achieved through the use of organizational resources.
answer

management
question

Which of the following is not a basic role of managers?
answer

entrepreneurial
question

Being a figurehead and leader is part of the _____ managerial role.
answer

interpersonal
question

Being an entrepreneur, disturbance handler, and negotiator is part of the _____ managerial role.
answer

decisional
question

_____ is the efficient and effective execution of specific tasks
answer

operational control
question

_____ is the acquisition and efficient use of resources in accomplishing organizational goals.
answer

management control
question

Computer support is greatest for which of the following problems?
answer

structured and operational control
question

Computer support is least for which of the following problems?
answer

unstructured and strategic planning
question

Searching for valuable business information in a database, data warehouse, or data mart is referred to as _____
answer

data mining
question

_____ provides users with a view of what is happening, whereas _____ addresses why it is happening
answer

Multidimensional data analysis, data mining
question

Credit card companies would most likely use which of the following to check for fraudulent credit card use?
answer

data mining
question

A company wants to use data from past promotional mailings to identify people who would likely respond favorably to future mailings. This company would most likely use:
answer

data mining
question

Which of the following is not a characteristic of DSSs?
answer

They support only lower- and middle-level managers
question

At the end of a semester, a student knows that she must achieve a grade of 81 or higher on her final exam to get an A in the course. She has just performed what kind of analysis?
answer

goal-seeking
question

_____ attempts to find the value of the inputs necessary to achieve a desired level of output
answer

goal-seeking analysis
question

Which of the following is not a characteristic of organizational decision support systems?
answer

they are standalone systems
question

A(n) _____ provides rapid access to timely information and direct access to management reports
answer

digital dashboard
question

Which capability of digital dashboards enables users to obtain the latest data available on key performance indicators or some other metric, ideally in real time?
answer

status access
question

Which of the following information systems are very user friendly, supported by graphics, and provide exception reporting and drill down?
answer

digital dashboards
question

Digital dashboards provide all of the following capabilities except:
answer

transaction processing
question

The management cockpit best exemplifies which type of system?
answer

digital dashboard
question

The primary distinguishing characteristic of geographical information systems is:
answer

every record or digital object has an identified geographical location
question

Geocoding involves:
answer

integrating maps with spatially oriented databases and other databases
question

Today, geographical information systems are being combined with _____ to form geospatial technologies
answer

global positioning systems
question

Which of the following factors is not increasing the threats to information security?
answer

limited storage capacity on portable devices
question

The computing skills necessary to be a hacker are decreasing for which of the following reasons?
answer

Computer attack programs, called scripts, are available for download from the Internet.
question

Rank the following in terms of dollar value of the crime, from highest to lowest
answer

cybercrime – white collar crime – robbery
question

A _____ is any danger to which an information resource may be exposed
answer

threat
question

An information system’s _____ is the possibility that the system will be harmed by a threat
answer

vulnerability
question

_____ involves building an inappropriate trust relationship with employees for the purpose of gaining sensitive information or unauthorized access privileges.
answer

social engineering
question

A _____ is intellectual work that is known only to a company and is not based on public information
answer

trade secret
question

A pharmaceutical company’s research and development plan for a new class of drugs would be best described as which of the following?
answer

a trade secret
question

A _____ is a document that grants the holder exclusive rights on an invention for 20 years.
answer

patent
question

An organization’s e-mail policy has the least impact on which of the following software attacks?
answer

zero-day
question

_____ are segments of computer code that attach to existing computer programs and perform malicious acts.
answer

viruses
question

_____ are software programs that hide in other computer programs and reveal their designed behavior only when they are activated
answer

trojan horses
question

_____ are segments of computer code embedded within an organization’s existing computer programs that activate and perform a destructive action at a certain time or date
answer

logic bombs
question

A _____ attack uses deception to fraudulently acquire sensitive personal information by masquerading as an official e-mail
answer

phishing
question

In a _____ attack, a coordinated stream of requests is launched against a target system from many compromised computers at the same time
answer

distributed denial-of-service
question

_____ is the process in which an organization assesses the value of each asset being protected, estimates the probability that it will be compromised, and compares the probable costs of an attack with the costs of protecting the asset
answer

risk analysis
question

Which of the following statements is false?
answer

It is easy to assess the value of a hypothetical attack
question

In _____, the organization takes concrete actions against risks.
answer

risk mitigation
question

Which of the following is not a strategy for mitigating the risk of threats against information?
answer

all of the above are strategies for mitigating risk
question

In _____, the organization purchases insurance as a means to compensate for any loss
answer

risk transference
question

Which of the following statements concerning the difficulties in protecting information resources is not correct?
answer

Rapid technological changes ensure that controls are effective for years
question

_____ controls are concerned with user identification, and they restrict unauthorized individuals from using information resources
answer

access
question

Access controls involve _____ before _____
answer

authentication, authorization
question

Biometrics are an example of:
answer

something the user is
question

Voice and signature recognition are examples of:
answer

something the user does
question

Passwords and passphrases are examples of:
answer

something the user knows
question

Which of the following is not a characteristic of strong passwords?
answer

they tend to be short so they are easy to remember
question

Which of the following is true?
answer

The actual processing of a Transaction has to be standard
question

Which of the following is false?
answer

Information systems are only used by large organizations
question

Organizational transactions are typically _____ volume, _____, and therefore _____ to computerize
answer

high, repetitive, easy
question

Business transactions that are processed as they occur is an example of
answer

OLTP
question

The most fundamental information systems in an organization are:
answer

transaction processing systems
question

When interest is credited to your savings account at your bank, it is called a:
answer

transaction
question

Crediting interest to your savings account at your bank once a month, it is called a:
answer

process
question

Data that have been processed by the organization’s _____ are inputs into the organization’s database.
answer

transaction processing systems
question

Which of the following is not a characteristic of a transaction processing system?
answer

small amounts of data are processed
question

Which of the following is not an example of a transaction?
answer

printing a report
question

Which of the following is false?
answer

TPS need large computers to process the transactions.
question

Which of the following is not a function of functional area information systems?
answer

providing data from business events to the corporate database
question

Which of the following is not a process within an information system for Accounting and Finance?
answer

inventory management
question

Which of the following is false?
answer

ERP systems look the same to users as functional information systems
question

Enterprise resource planning systems take a(n) _____ view of the overall organization
answer

business process
question

_____ integrate the planning, management, and use of all of an organization’s resources, and are designed to tightly integrate the functional areas of the organization
answer

enterprise resource planning systems
question

Enterprise resource planning systems are very _____ software products, meaning that companies typically have to change their _____ to accommodate how the software functions
answer

structured, business processes
question

_____ are interorganizational ERP systems that provide Web-enabled links between an organization’s key business systems and its customers, suppliers, business partners, and others
answer

ERP II systems
question

The drawbacks of ERP systems include all of the following except:
answer

they consist of modules
question

Which of the following was not included in early ERP systems?
answer

sales and marketing
question

Which of the following is false about ERP II systems?
answer

These ERP systems have no optional modules
question

_____ reports contain special information not found in routine reports
answer

ad hoc
question

_____ reports are produced at scheduled intervals
answer

routine
question

_____ reports summarize the performance of critical activities
answer

key indicator
question

When the chief financial officer of a company wants a report on business units who have spent 10 percent more than their allotted budget, she would be requesting which type of report?
answer

exception
question

_____ reports include only information that falls outside certain threshold standards
answer

exception
question

To effectively manage by exception (i.e., use exception reports), the company must first create:
answer

performance standards
question

Which of the following is an important enabler of CRM?
answer

recognizing that there are many customer touch points
question

Which of the following is not a customer touch point?
answer

none of these – all are touch points
question

The complete data on a customer is called:
answer

a 360-degree view
question

Which of the following is the most important enabler of the 360-degree view of the customer across an organization?
answer

the organization’s data warehouse
question

_____ systems provide interactive communication with the customer throughout the organization
answer

collaborative CRM
question

Which of the following statements concerning customer relationship management is false?
answer

CRM constitutes a specific use of technology
question

Which of the following statements is false?
answer

Data consolidation and a 360-degree view mean the same thing
question

_____ systems support the front-office business processes which directly interact with customers
answer

Operational CRM
question

_____ includes those areas where customers directly interact with the company
answer

customer-facing CRM
question

Which of the follow statements concerning customer interaction centers (CIC) is false?
answer

In inboard telesales, the customer calls the CIC
question

The sales, marketing, and service functions are part of:
answer

operational CRM
question

In _____, company representatives use multiple communication channels to support their customers’ communications preferences
answer

customer interaction centers
question

_____ is the component of an operational CRM system that automatically records all the aspects in a sales transaction process
answer

sales force automation
question

_____ is the practice of marketing additional related products to customers based on a previous purchase.
answer

cross-selling
question

AT&T sells telephone services that include local and long-distance service, voice mail service, caller ID, and digital subscriber line access to the Internet. This is a form of:
answer

bundling
question

You are in the market for a small economy car. The salesperson has you drive the economy car, and then hands you the keys to a mid-sized car of the same brand for you to drive. The salesperson is engaged in:
answer

up-selling
question

_____ is a sales strategy which the business person will provide customers the opportunity to purchase higher-value related products
answer

up-selling
question

_____ occurs when a business sells a group of products or services together at a lower price than the combined individual prices of the products
answer

bundling
question

_____ is a form of _____
answer

bundling, cross-selling
question

Which of the following statements about loyalty programs is false?
answer

The purpose of loyalty programs is to reward past behavior
question

_____ systems study customer behavior and perceptions to provide business intelligence
answer

Analytical CRM
question

_____ creates statistical models of customer behavior and the value of customer relationships over time
answer

Analytical CRM
question

_____ examines customer data in detail for designing and executing targeted marketing campaigns
answer

Analytical CRM
question

_____ is a CRM system that is hosted by an external vendor in the vendor’s data center
answer

on-demand CRM
question

Potential problems with on-demand CRM include all of the following except:
answer

it increases costs for the organization
question

Trends that have led to the supply chain concept include all of the following except:
answer

modern organizations are buying their suppliers in order to have more transparency along the supply chain
question

_____ is the ability for all organizations in a supply chain to access or view relevant data on purchased materials as these materials move through their suppliers’ production processes and transportation networks to their receiving docks
answer

Supply chain visibility
question

_____ is the time between the receipt of incoming goods and the dispatch of finished, outbound products
answer

inventory velocity
question

A(n) _____ refers to the flow of materials, information, money, and services from raw material suppliers, through factories and warehouses to the end customers
answer

supply chain
question

The _____ is comprised of a company’s suppliers, the suppliers’ suppliers, and the processes for managing them
answer

upstream portion of the supply chain
question

Packaging, assembly, and manufacturing take place in which segment of the supply chain?
answer

internal
question

The ________ refers to a company’s organization and processes for distributing and delivering products to its final customers
answer

downstream portion of the supply chain
question

Distribution or dispersal takes place in which segment of the supply chain?
answer

downstream
question

_____ are the physical products, raw materials, and supplies that flow along a supply chain
answer

material flows
question

Returned products, recycled products, and disposal of materials or products are called:
answer

reverse flows
question

_____ consist of data that are related to demand, shipments, orders, returns, and schedules
answer

information flows
question

_____ involve money transfers, payments, credit card information and authorization, payment schedules, e-payments, and credit-related data
answer

financial flows
question

The goals of supply chain management include which of the following?
answer

all of these
question

Which of the following is not a goal of supply chain management?
answer

to increase cycle time
question

Interorganizational information systems result in all of the following except:
answer

increased cycle time
question

In the _____, the production process begins with a forecast
answer

push model
question

In the _____, the production process begins with a customer order
answer

pull model
question

The _____ is known as make-to-stock
answer

push model
question

The _____ is known as make-to-order
answer

pull model
question

Which of the following models best describes the business model of large automobile manufacturers?
answer

push model
question

The primary goal of extranets is to ______
answer

foster collaboration between and among business partners
question

Extranets use _____ technology to make communication over the Internet more secure
answer

virtual private network
question

The FedEx extranet that allows customers to track the status of a package is an example of which type of extranet?
answer

a company and its dealers, customers, and/or suppliers
question

The Bank of America extranet for commercial loans links lenders, loan brokers, escrow companies, title companies, and others. This is an example of which type of extranet?
answer

joint venture
question

_____ portals automate the business processes involved in purchasing products between a single buyer and multiple suppliers
answer

procurement
question

_____ portals automate the business processes involved in selling products from a single supplier to multiple buyers
answer

distribution
question

Place the stages of the systems development life cycle in order:
answer

(CHOICE A!) Investigation – analysis – design – programming/testing – implementation – operation/maintenance
question

The _____ that changes are made in the systems development life cycle, the _____ expensive these changes become)
answer

sooner, less
question

Which of the following is not a part of systems analysis?
answer

Identifying the technical specifications of the solution
question

In the traditional systems development life cycle, users:
answer

provide information requirements
question

The deliverable of the systems design stage is:
answer

technical system specifications
question

Systems design answers the question, _____:
answer

How will the information system resolve the business problem?
question

When users ask for added functionality during a systems development project, this is called:
answer

scope creep
question

Which of the following statements about scope creep is true?
answer

Because scope creep is expensive, successful project managers limit it.
question

In the _____ stage of the systems development life cycle, the design specifications are translated into computer code
answer

programming
question

_______ conversion is the riskiest type of conversion process
answer

direct
question

A firm shuts down its old COBOL legacy system and immediately starts up its new PeopleSoft ERP system. This process is called __________ conversion
answer

direct
question

A firm implements a new information system in one of its plants, assesses the new system’s performance, and then implements the new system in its other plants. This is an example of __________ conversion
answer

pilot
question

As systems age, maintenance costs _____
answer

increase

Get instant access to
all materials

Become a Member