1) Which of the following best illustrates the relationship between entities and attributes?
A) The entity CUSTOMER with the attribute PRODUCT
B) The entity CUSTOMER with the attribute PURCHASE
C) The entity PRODUCT w
...
1) Which of the following best illustrates the relationship between entities and attributes?
A) The entity CUSTOMER with the attribute PRODUCT
B) The entity CUSTOMER with the attribute PURCHASE
C) The entity PRODUCT with the attribute PURCHASE
D) The entity PRODUCT with the attribute CUSTOMER
E) The entity PURCHASE with the attribute CUSTOMER
Answer: B
Difficulty: Challenging
AACSB: Analytical thinking
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
2) All of the following are issues with the traditional file environment except:
A) data inconsistency.
B) inability to develop specialized applications for functional areas.
C) lack of flexibility in creating ad-hoc reports.
D) poor security.
E) data sharing.
Answer: B
Difficulty: Challenging
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
3) A characteristic or quality that describes a particular database entity is called a(n):
A) field.
B) tuple.
C) key field.
D) attribute.
E) relationship.
Answer: D
Difficulty: Easy
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
4) A ________ is an example of pre-digital data storage that is comparable to a database.
A) library card catalog
B) cash register receipt
C) doctor's office invoice
D) list of sales totals on a spreadsheet
E) schedule of due dates on a project outline
Answer: A
Difficulty: Moderate
AACSB: Analytical thinking
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
1
5) ________ creates confusion that hampers the creation of information systems that integrate
data from different sources.
A) Batch processing
B) Data redundancy
C) Data independence
D) Online processing
E) Data quality
Answer: B
Difficulty: Easy
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
6) Data ________ occurs when the same data is duplicated in multiple files of a database.
A) redundancy
B) repetition
C) independence
D) partitions
E) discrepancy
Answer: A
Difficulty: Easy
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
7) Which of the following occurs when the same attribute in related data files has different
values?
A) Data redundancy
B) Data duplication
C) Data dependence
D) Data discrepancy
E) Data inconsistency
Answer: E
Difficulty: Challenging
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
8) Which of the following is a grouping of characters into a word, a group of words, or a
complete number?
A) File
B) Table
C) Entity
D) Field
E) Tuple
Answer: D
Difficulty: Easy
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
9) The fact that a traditional file system cannot respond to unanticipated information
2
requirements in a timely fashion is an example of which of the following issues with traditional
file systems?
A) Program-data dependence
B) Lack of flexibility
C) Poor security
D) Lack of data sharing
E) Data redundancy
Answer: B
Difficulty: Moderate
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
10) A record is a characteristic or quality used to describe a particular entity.
Answer: FALSE
Difficulty: Easy
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
11) 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.
Answer: TRUE
Difficulty: Moderate
AACSB: Information technology
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
12) You have been asked to design a new contracts database for a small publishing company.
What fields do you anticipate needing? Which of these fields might be in use in other databases
used by the company?
Answer: Author first name, author last name, author address, agent name and address, title of
book, book ISBN, date of contract, amount of money, payment schedule, date contract ends.
Other databases might be an author database (author names, address, and agent details), a book
title database (title and ISBN of book), and financial database (payments made).
Difficulty: Moderate
AACSB: Analytical thinking
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
3
13) List at least three conditions that contribute to data redundancy and inconsistency.
Answer: Data redundancy occurs when different divisions, functional areas, and groups in an
organization independently collect the same piece of information. Because it is collected and
maintained in so many different places, the same data item may have:
1. different meanings in different parts of the organization,
2. different names may be used for the same item, and
3. different descriptions for the same condition.
In addition, the fields into which the data is gathered may have different field names, different
attributes, or different constraints.
Difficulty: Moderate
AACSB: Analytical thinking
LO: 6-1: What are the problems of managing data resources in a traditional file environment?
14) Which of the following enables a DBMS to reduce data redundancy and inconsistency?
A) Ability to enforce referential integrity
B) Ability to couple program and data
C) Use of a data dictionary
D) Ability to create two-dimensional tables
E) Ability to minimize isolated files with repeated data
Answer: E
Difficulty: Challenging
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
15) A DBMS makes the:
A) physical database available for different logical views.
B) relational database available for different logical views.
C) physical database available for different analytic views.
D) relational database available for different analytic views.
E) logical database available for different analytic views.
Answer: A
Difficulty: Challenging
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
4
16) The logical view of a database:
A) displays the organization and structure of data on the physical storage media.
B) includes a digital dashboard.
C) allows the creation of supplementary reports.
D) enables users to manipulate the logical structure of the database.
E) presents data as they would be perceived by end users.
Answer: E
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
17) Which of the following is a DBMS for desktop computers?
A) DB2
B) Oracle Database
C) Microsoft SQL Server
D) Microsoft Access
E) Microsoft Exchange
Answer: D
Difficulty: Challenging
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
18) A(n) ________ represent data as two-dimensional tables.
A) non-relational DBMS
B) mobile DBMS
C) relational DBMS
D) hierarchical DBMS
E) object-oriented DBMS
Answer: C
Difficulty: Easy
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
19) Microsoft SQL Server is a(n):
A) DBMS for both desktops and mobile devices.
B) Internet DBMS.
C) desktop relational DBMS.
D) DBMS for midrange computers.
E) DBMS for mobile devices.
Answer: D
Difficulty: Challenging
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
5
20) In a table for customers, the information about a single customer resides in a single:
A) field.
B) row.
C) column.
D) table.
E) entity.
Answer: B
Difficulty: Easy
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
21) In a relational database, a record is referred to in technical terms as a(n):
A) tuple.
B) table.
C) entity.
D) field.
E) key.
Answer: A
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
22) A field identified in a table as holding the unique identifier of the table's records is called
the:
A) primary key.
B) key field.
C) primary field.
D) unique ID.
E) primary entity.
Answer: A
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
6
23) A field identified in a record as holding the unique identifier for that record is called the:
A) primary key.
B) key field.
C) primary field.
D) unique ID.
E) key attribute.
Answer: B
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
24) In a relational database, the three basic operations used to develop useful sets of data are:
A) select, project, and where.
B) select, join, and where.
C) select, project, and join.
D) where, from, and join.
E) where, find, and select.
Answer: C
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
25) The select operation:
A) combines relational tables to provide the user with more information than is otherwise
available.
B) creates a subset consisting of columns in a table.
C) identifies the table from which the columns will be selected.
D) creates a subset consisting of all records in the file that meet stated criteria.
E) creates a subset consisting of rows in a table.
Answer: D
Difficulty: Easy
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
7
26) The join operation:
A) combines relational tables to provide the user with more information than is otherwise
available.
B) identifies the table from which the columns will be selected.
C) creates a subset consisting of columns in a table.
D) organizes elements into segments.
E) creates a subset consisting of rows in a table.
Answer: A
Difficulty: Easy
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
27) The project operation:
A) combines relational tables to provide the user with more information than is otherwise
available.
B) creates a subset consisting of columns in a table.
C) organizes elements into segments.
D) identifies the table from which the columns will be selected.
E) creates a subset consisting of rows in a table.
Answer: B
Difficulty: Easy
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
28) Microsoft Access's data dictionary displays all of the following information about a field
except the:
A) size of the field.
B) format of the field.
C) description of the field.
D) type of the field.
E) the organization within the organization that is responsible for maintaining the data.
Answer: E
Difficulty: Challenging
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
8
29) Which of the following is an automated or manual file that stores information about data
elements and data characteristics such as usage, physical representation, ownership,
authorization, and security?
A) Data dictionary
B) Data definition diagram
C) Entity-relationship diagram
D) Relationship dictionary
E) Data table
Answer: A
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
30) Which of the following is a specialized language that programmers use to add and change
data in the database?
A) Data access language
B) Data manipulation language
C) Structured query language
D) Data definition language
E) DBMS
Answer: B
Difficulty: Easy
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
31) Which of the following is the most prominent data manipulation language today?
A) Access
B) DB2
C) SQL
D) Crystal Reports
E) NoSQL
Answer: C
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
9
32) DBMSs typically include report generating tools in order to:
A) retrieve and display data.
B) display data in an easier-to-read format.
C) display data in graphs.
D) perform predictive analysis.
E) analyze the database's performance.
Answer: B
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
33) The process of streamlining data to minimize redundancy and awkward many-to-many
relationships is called:
A) normalization.
B) data scrubbing.
C) data cleansing.
D) data defining.
E) optimization.
Answer: A
Difficulty: Easy
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful?
34) A schematic of the entire database that describes the relationships in a database is called
a(n):
A) data dictionary.
B) intersection relationship diagram.
C) entity-relationship diagram.
D) data definition diagram.
E) data analysis table.
Answer: C
Difficulty: Moderate
AACSB: Information technology
LO: 6-2: What are the major capabilities of database management systems (DBMS) and why is
a relational DBMS so powerful
[Show More]
