Quiz 3 – Flashcard Answers
Unlock all answers in this set
Unlock answersquestion
A ________ is a climate-controlled building or set of buildings that houses database servers and the systems that deliver mission-critical information and services.
answer
data center
question
A ________ is s field or set of fields in a record that uniquely defines the record.
answer
primary key
question
A collection of fields all related to a single object, activity, or individual is a(n) _____.
answer
record
question
A database _____.
answer
helps companies reduce costs, increase profits, track past business activities, and open new market opportunities
question
A database is a collection of integrated and related _____.
answer
files
question
A department within an organization that focuses on generating profits is called a(n) ______.
answer
profit center
question
A form of database that holds a duplicate set of frequently used data and that helps reduce telecommunications costs.
answer
replicated
question
A tool that database designers use to show the logical relationships among data is a(n) _____.
answer
all of the above
question
A typical DSS includes many components including the _____ which allows decision makers to easily access and manipulate the DSS and to use common business terms and phrases.
answer
dialogue manager
question
A(n) _____ MIS supports managerial activities in product development, distribution, pricing, promotions, and sales forecasting.
answer
marketing
question
A(n) _____ contains a subset of data for a single aspect of a company's business and are used by smaller groups who want to access detailed data for business analysis.
answer
data mart
question
A(n) _____ is a simple database program whose records have no relationship to one another.
answer
flat file
question
An effective _____ MIS enables an organization to keep personnel costs at a minimum while serving the required business processes needed to achieve corporate goals.
answer
HR
question
An executive support system _____.
answer
can present structured information about aspects of the organization that executives consider important
question
As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.
answer
attribute
question
Basic data manipulations include _____ which involves eliminating rows in a relational database.
answer
selecting
question
Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.
answer
drill down
question
Decision support systems _____.
answer
all of the above
question
Developers of ______ systems try to build on the advantages of individual support systems while adding new approaches unique to group decision making.
answer
GSS
question
Developing a seamless integration of databases with the Internet is something called a(n) ______.
answer
semantic web
question
During the _____ stage of the problem solving process, you select a course of action.
answer
choice
question
Group support system alternatives include ______.
answer
all of the above
question
One characteristic of a structured problem is that _____.
answer
it is straightforward, requiring known facts and relationships
question
Some databases use ______, which is a visual approach to developing queries and requests.
answer
Query by Example (QBE)
question
Subsystems for the marketing MIS and their outputs help marketing managers and executives to _____.
answer
reduce marketing expenses
question
______ is a form of database processing that supports top-down, query-driven data analysis.
answer
Online analytical processing (OLAP)
question
______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
answer
data definition language
question
_____ represents huge amounts of unstructured data that is difficult to capture, store, and manipulate using traditional database management systems.
answer
big data
question
_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.
answer
data mining
question
_____ is a standardized data manipulation language developed in the 1970s that allows programmers to use one powerful language and use it on a variety of systems.
answer
SQL
question
_____ is a common characteristic of an executive support system.
answer
Designed for use in a group setting
question
_____ describes the steps an organization takes to protect information sought by "hostile" intelligence gathers.
answer
Counterintelligence
question
_____ combines historical data with assumptions about future conditions to predict the outcomes of events.
answer
Predictive analysis
question
With _____, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet.
answer
Database as a Service
question
The smallest piece of data used by a computer is the _____.
answer
bit
question
The second stage in the problem solving process during which you develop alternative solutions to the problem and evaluate their feasibility.
answer
design
question
The performance of decision support systems is typically a function of decision quality and _____.
answer
problem complexity
question
The goal of a(n) _____ system is to tie together all aspects of production, including order processing, product design, manufacturing, inspection and quality control, and shipping.
answer
computer integrated manufacturing
question
The focus of a DSS is on decision-making _____ when faced with unstructured or semistructured business problems.
answer
effectiveness
question
The _____ is a description that involves "telling" the DBMS the logical and physical structure of the data and the relationships among the data for each user.
answer
schema
