Transcript mis9_ch07_crsppt

When working with a
database, a group of related
fields comprises a(n)…
1.
2.
3.
4.
5.
file.
database.
entity.
record.
attribute.
When working with a
database, a group of related
fields comprises a(n)…
1.
2.
3.
4.
5.
file.
database.
entity.
record.
attribute.
Fields are groups of characters such as a word, group of words,
or a complete number.
A person, place, thing, or
event on which we store
and maintain information
using records is a(n)…
1.
2.
3.
4.
5.
file.
database.
entity.
field.
attribute.
A person, place, thing, or
event on which we store
and maintain information
using records is a(n)…
1.
2.
3.
4.
5.
file.
database.
entity.
field.
attribute.
An entity can be a customer (person), retail store (place), order
(thing), or holiday shopping season (event).
A field in each record
that uniquely identifies
that record is called a…
1.
2.
3.
4.
5.
secondary field.
primary field.
key field.
first field.
customer field.
A field in each record
that uniquely identifies
that record is called a…
1.
2.
3.
4.
5.
secondary field.
primary field.
key field.
first field.
customer field.
Every record in a file should contain at least one field that
uniquely identifies that record so the record can be retrieved,
updated, or sorted.
Which of the following
is not a problem with
the traditional file
environment?
1.
2.
3.
4.
5.
Data security
Program-data dependence
Data redundancy
Easily sharing data
Inflexibility
Which of the following
is not a problem with
the traditional file
environment?
1.
2.
3.
4.
5.
Data security
Program-data dependence
Data redundancy
Easily sharing data
Inflexibility
In most organizations, systems tend to grow independently and
not according to some grand plan. Over time, problems occur
with data redundancy and inconsistency, program-data
dependence, inflexibility, poor data security, and an inability to
share data among applications.
Which of the following
occurs when the same
data are stored in more
than one place or
location?
1. Program-data dependence
2. Data redundancy
3. Inflexible database retrieval
4. Lack of data sharing
5. Data inconsistency
Which of the following
occurs when the same
data are stored in more
than one place or
location?
1. Program-data dependence
2. Data redundancy
3. Inflexible database retrieval
4. Lack of data sharing
5. Data inconsistency
Data redundancy occurs when different divisions, functional
areas, and groups in an organization independently collect the
same piece of data and store it independently of each other.
Which of the following
refers to the situation in
which a change in a
software program could
require a change in the
data used by that
program?
1. Program-data dependence
2. Data redundancy
3. Inflexible database
retrieval
4. Lack of data sharing
5. Data inconsistency
Which of the following
refers to the situation in
which a change in a
software program could
require a change in the
data used by that
program?
1. Program-data dependence
2. Data redundancy
3. Inflexible database retrieval
4. Lack of data sharing
5. Data inconsistency
Program-data dependence refers to the coupling of data stored
in files and the specific programs required to update and
maintain those files such that changes in programs require
changes to the data.
The software that acts
as an interface between
application programs
and the physical data
files is…
1. middleware.
2. shareware.
3. enterprise application software.
4. database management system.
5. operating system.
The software that acts
as an interface between
application programs
and the physical data
files is…
1. middleware.
2. shareware.
3. enterprise application software.
4. database management system.
5. operating system.
A database management system is simply the software that
permits an organization to centralize data, manage them
efficiently, and provide access to the stored data by application
programs.
Which of the following
refers to the presentation
of data as they would be
perceived by end users?
1. Conceptual schema
2. Logical view
3. Physical view
4. Physical schema
5. Subschema
Which of the following
refers to the presentation
of data as they would be
perceived by end users?
1. Conceptual schema
2. Logical view
3. Physical view
4. Physical schema
5. Subschema
The physical view of data shows how they are actually organized
and structured on physical storage media.
The logical description of
the entire database
showing all the data
elements and
relationships among
them is called the …
1. conceptual schema.
2. logical view.
3. physical view.
4. physical schema.
5. subschema.
The logical description of
the entire database
showing all the data
elements and
relationships among them
is called the …
1. conceptual schema.
2. logical view.
3. physical view.
4. physical schema.
5. subschema.
The specifications of how data from the conceptual schema are
stored on physical media is termed the physical schema or
internal schema.
Which of the following
is not a component of a
database management
system?
1. Enterprise applications
2. Data definition language
3. Data manipulation language
4. Data dictionary
5. Not sure
Which of the following
is not a component of a
database management
system?
1. Enterprise applications
2. Data definition language
3. Data manipulation language
4. Data dictionary
5. Not sure
A database management system must have a data definition
language, a data manipulation language, and a data dictionary.
An automated file that
stores definitions of data
elements and data
characteristics is called
a(n)…
1. data definition language.
2. data manipulation language.
3. data dictionary.
4. application program.
5. Not sure
An automated file that
stores definitions of data
elements and data
characteristics is called
a(n)…
1. data definition language.
2. data manipulation language.
3. data dictionary.
4. application program.
5. Not sure
The data dictionary can produce lists and reports of data use,
groupings, and program locations.
Which type of data model
represents all data in the
database as simple twodimensional tables?
1. Hierarchical
2. Table
3. Network
4. Relational
5. Not sure
Which type of data model
represents all data in the
database as simple twodimensional tables?
1. Hierarchical
2. Table
3. Network
4. Relational
5. Not sure
The relational DBMS is the most popular type for PCs as well as
for larger computers and mainframes.
Which of the following is
not a basic operation in a
relational database?
1. Select
2. Join
3. Project
4. Print
5. Not sure
Which of the following is
not a basic operation in a
relational database?
1. Select
2. Join
3. Project
4. Print
5. Not sure
The select operation creates a subset of all records that meet the
stated criteria. The join operation combines relational tables. The
project operation creates a subset of columns in a table, creating
new tables that contain only the information required.
Which of the following is
not a characteristic of
data structures that have
been normalized?
1. Small
2. Stable
3. Flexible
4. Adaptive
5. Networked
Which of the following is
not a characteristic of
data structures that have
been normalized?
1. Small
2. Stable
3. Flexible
4. Adaptive
5. Networked
To use a relational database model effectively, complex
groupings of data must be streamlined to minimize redundant
data elements and awkward many-to-many relationships through
the process of normalization.
A database that stores
current and historical
data of potential interest
to managers throughout
the company is called a
data …
1. mine.
2. warehouse.
3. store.
4. network.
5. crate.
A database that stores
current and historical
data of potential interest
to managers throughout
the company is called a
data …
1. mine.
2. warehouse.
3. store.
4. network.
5. crate.
The data stored in a data warehouse originate in many core
operational systems and external sources. The data are
standardized into a common data model and consolidated so
that they can be used across the enterprise for management
analysis and decision making.
Which of the following is
often used to provide
information for targeted
marketing campaigns?
1. Data mining
2. Data warehousing
3. Data storing
4. Data networking
5. Data crating
Which of the following is
often used to provide
information for targeted
marketing campaigns?
1. Data mining
2. Data warehousing
3. Data storing
4. Data networking
5. Data crating
Data mining uses a variety of techniques to find hidden patterns
and relationships in large pools of data and infer rules from them
that can be used to predict future behavior and guide decision
making.
Which of the following
allows users to access
topics on a Web site in
whichever order they
wish?
1. Structured Query Languages
2. Hypermedia databases
3. Ad-hoc query languages
4. Common gateway interface
5. Database servers
Which of the following
allows users to access
topics on a Web site in
whichever order they
wish?
1. Structured Query Languages
2. Hypermedia databases
3. Ad-hoc query languages
4. Common gateway interface
5. Database servers
The hypermedia database approach to information management
stores chunks of information in the form of nodes connected by
links the user specifies. The nodes can contain text, graphics,
sound, full-motion video, or executable computer programs.
A specification for
transferring information
between a Web server
and a program designed
to accept and return data
is called …
1. SQL script.
2. Data language script.
3. Java script.
4. Access script.
5. Common gateway interface.
A specification for
transferring information
between a Web server
and a program designed
to accept and return data
is called …
1. SQL script.
2. Data language script.
3. Java script.
4. Access script.
5. Common gateway interface.
Common gateway interfaces can be written in any programming
language.
An organizational
function with the power
to define information
requirements for the
entire company is called
a…
1. resource administration.
2. data administration.
3. database administration.
4. Data-mining administration.
5. Not sure
An organizational
function with the power
to define information
requirements for the
entire company is called
a…
1. resource administration.
2. data administration.
3. database administration.
4. data-mining administration.
5. Not sure
Data administration is responsible for the specific policies and
procedures through which data can be managed as an
organizational resource. The fundamental principle of data
administration is that all data are the property of the organization
as a whole.
A database design and
management group
performs the functions of
…
1. resources administration.
2. data administration.
3. database administration.
4. data-mining administration.
5. Not sure
A database design and
management group
performs the functions of
…
1. resources administration.
2. data administration.
3. database administration.
4. data-mining administration.
5. Not sure
The database design and management group establishes the
physical database, the logical relations among elements, and the
access rules and procedures.