CIS 2200 Final – Flashcards
Unlock all answers in this set
Unlock answersquestion
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