Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
The term that describes conceptual collections of related data fields is a(n):
1)
A)
entity.
B)
record.
C)
attribute.
D)
field.
2)
Which statement is false concerning the enterprise modeling approach?
2)
A)
It takes advantage of a broad view of the firm’s data resource.
B)
Information systems can easily share data.
C)
It addresses problems well.
D)
The synergy of the data resources between business areas can be leveraged.
3)
When defining a database in Microsoft Access, what property is used to force certain characters to
be entered in a particular manner?
3)
A)
validation rule
B)
default value
C)
input mask
D)
key field
4)
The term used to describe a request for the database to display selected records is:
4)
A)
question.
B)
query.
C)
sort.
D)
filter.
5)
Which statement is false concerning database end users?
5)
A)
There can be an increase in end–user errors because the database is easy to use.
B)
End users ask questions using query–by–example.
C)
End users generate forms and reports.
D)
End users need to know how to code SQL statements.
6)
Which view of the data in a database shows one record at a time?
6)
A)
queries
B)
tables
C)
forms
D)
reports
7)
Which database definition is the collection of data under the control of database management
system software?
7)
A)
general definition of a database
B)
relational database
C)
restrictive definition of a database
D)
database
8)
Which of the following is a disadvantage of DBMSs?
8)
A)
data redundancy
B)
data dependence
C)
obtain a large hardware configuration
D)
more security risks
9)
The database administrator’s role of offering educational programs to database users and
providing assistance when needed falls into which major area?
9)
A)
security
B)
planning
C)
operation
D)
implementation
10)
Which database structure was never widely adopted by business organizations today?
10)
A)
network
B)
relational
C)
object–oriented
D)
hierarchical
Explanation:
11)
A key in a table is a:
11)
A)
file.
B)
record.
C)
data field.
D)
data.
12)
The duties of the DBA fall into all of the following major areas except for:
12)
A)
database security.
B)
database implementation.
C)
database planning.
D)
performance statistics processor.
13)
Which statement is false concerning database programmers?
13)
A)
Database programmers are specialists.
B)
The consequences of a programming error could be felt by a very large number of users.
C)
Database programmers are often hired as entry–level programmers.
D)
Database programmers often write code to strip and/or aggregate data from a database.
14)
In the data hierarchy, which of the following represents the smallest unit of data?
14)
A)
data field
B)
database
C)
record
D)
file
15)
Which database feature can be used to limit a user’s access to data in the database?
15)
A)
sorting
B)
OLAP
C)
queries
D)
filtering
16)
Which of the following is not a major area for the database administrator?
16)
A)
security
B)
implementation
C)
programming
D)
planning
17)
The data modeling technique that consists of the named class, fields in the class, and actions that act
upon the class is called a(n):
17)
A)
class diagram.
B)
data flow diagram.
C)
object diagram.
D)
entity–relationship diagram.
18)
Which of the following is not a step in the problem–oriented approach to creating a database?
18)
A)
Describe information needs.
B)
Define the problem.
C)
Create an enterprise data model.
D)
Specify data needs.
19)
In the data hierarchy, what is a collection of files?
19)
A)
database
B)
data field
C)
data
D)
record
20)
When databases break information into multiple tables to avoid duplicate data, it is referred to as
reducing:
20)
A)
data accuracy.
B)
data consistency.
C)
data redundancy.
D)
data duplication.
Explanation:
21)
Which of the following is not a common method for accessing the database held in a database
management system?
21)
A)
reports
B)
forms
C)
queries
D)
tables
22)
The advantages of DBMSs include all of the following except for:
22)
A)
achieve data independence.
B)
reduce hardware costs.
C)
reduce data redundancy.
D)
improve security.
B
23)
The database feature that allows data analysis similar to statistical cross–tabulation is:
23)
A)
data mining.
B)
query.
C)
filtering.
D)
OLAP.
D
24)
Which of the following disadvantages of using a database management system becomes less
important with each passing year?
24)
A)
obtaining expensive software
B)
obtaining a large hardware configuration
C)
hiring and maintaining a DBA staff
D)
the amount of computer resources increases with more users
A
25)
Which statement is false regarding the hierarchical database structure?
25)
A)
GE developed it in 1964.
B)
It works well when only a few records are needed.
C)
The structure can look like branches on a tree.
D)
It influenced the work of CODASYL.
B
D
26)
Which database structure was the first database management system developed by GE?
26)
A)
relational
B)
object–oriented
C)
hierarchical
D)
network
27)
Which of the following is not an advantage of using a database management system?
27)
A)
Retrieve data and information rapidly.
B)
Achieve data dependence.
C)
Reduce data redundancy.
D)
Improve security.
28)
When changes to the data structure are made without affecting the application programs that
process the data, it is referred to as:
28)
A)
data consistency.
B)
data dependence.
C)
data duplication.
D)
data independence.
29)
The term that refers to the definition of data stored within the database and controlled by the
database management system is referred to as the:
29)
A)
data dictionary.
B)
database repository.
C)
database concept.
D)
database dictionary.
30)
The modeling technique that deals with data in entities and the relationships between entities is
referred to as a(n):
30)
A)
object diagram.
B)
entity–relationship diagram.
C)
data flow diagram.
D)
class diagram.
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
31)
A ________ is a collection of files.
31)
32)
In A ________ includes the definitions of the data stored within the database and
controlled by the database management system.
32)
33)
A________ is a field that uniquely identifies each table row but that was not chosen to be
the key.
33)
34)
A ________ is a request for the database to display selected records.
34)
35)
________ are aggregated data from the database that are formatted in a manner that aids
decision making.
35)
36)
A ________ is a collection of related records.
36)
37)
The ________ was developed to allow retrieval of specific records.
37)
38)
________ relationships can be implied from the data.
38)
39)
________ is a formal process for eliminating redundant data fields while preserving the
ability of the database to add, modify, and delete records without causing errors.
39)
40)
________ typically show one record at a time, do not provide summary data, and generally
do not aggregate data from many database tables.
40)
41)
________ consist of the named class, fields in the class, and actions that act upon the class.
41)
Explanation:
42)
The logical integration of records across multiple physical locations is called the ________.
42)
43)
Databases reduce ________ in tables.
43)
44)
________ is the ability to make changes in the data structure without making changes to
the application programs that process the data.
44)
45)
________ is a table that does not have repeating columns.
45)
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
46)
The role of the end user is to maintain a secure database.
46)
47)
When a manager wants only a few selected records from the very large number of records in the
database, the hierarchical structure is inefficient.
47)
48)
Subforms help to enforce the accuracy and consistency that databases require.
48)
49)
Data mining, data marts, and data warehousing refer to the family of concepts that view the firm’s
data as a treasure box to be opened, examined, and conquered.
49)
50)
The network database structure allows the retrieval of specific records with a given record to point
to any other record in the database.
50)
51)
Entity–relationship diagrams are used to describe relationships between conceptual collections of
data so that their related records can be joined together.
51)
52)
A restrictive definition of a database is the collection of data under the control of database
management system software.
52)
53)
Sometimes tables that originally stand alone as independent may later be required to be joined.
53)
54)
Entity–relationship diagrams give deeper insights into how data and applications work together
than do class diagrams.
54)
55)
Databases store data in single tables to reduce data redundancy.
55)
56)
Structured query language is the method of choice for interacting with Web–based databases.
56)
57)
One of the disadvantages of having a database management system is that a specialized database
management staff must be hired and maintained.
57)
58)
Relational database structures are based on implicit relationships.
58)
59)
Firms want database programmers to be chosen from the most skilled personnel available.
59)
60)
A record is a collection of data files.
60)
61)
A database management system enables the firm to reduce data redundancy and achieve data
dependence.
61)
62)
Another name for the process–oriented approach to creating a database is the problem–oriented
approach.
62)
63)
A flat file is a table that does not have repeating columns.
63)
64)
Database operation represents a high level of specialization and selection.
64)
65)
Database planning involves working with business area managers to define the firm’s data needs.
65)
66)
A database management system is a hardware configuration that stores the structure of the
database, the data itself, relationships among data in the database, and forms and reports
pertaining to the database.
66)
67)
A candidate key is a field that does not uniquely identify each table row and can be used as a key.
67)
68)
Class diagrams are used to describe the data relationships and the actions that operate on the data
in the relationships.
68)
69)
Data dictionary is the term that refers to the definition of data stored within the database and
controlled by the database management system.
69)
70)
The strength of the enterprise modeling approach is that it addresses problems well.
70)
71)
The majority of users’ interactions with databases are via reports and forms.
71)
72)
Two primary goals of the database concept are to minimize data redundancy and achieve data
dependence.
72)
73)
Structured query language is presented as a standardized form that the user completes to generate
a query.
73)
74)
In practice, entity–relationship diagrams are developed after the database has been created.
74)
75)
IBM developed the first database management system in 1965.
75)
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
76)
Briefly explain the three database structures discussed in this chapter.
77)
List the steps that occur for a process–oriented approach to creating a database.
78)
What are the three definitions of a database?
79)
Name the key personnel involved with databases and briefly describe their roles.
80)
What are the advantages and disadvantages of database management systems?
11