Question 1

The strength of the enterprise modeling approach is that it addresses problems well.

Accepted Answer

A) True 
 B)False

Question 2

__________consist of the named class, fields in the class, and actions that act upon the class.

Accepted Answer

The answer of __________consist of the named class, fields in...

Question 3

The role of the end user is to maintain a secure database.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not an advantage of using a database management system?

Accepted Answer

A) Retrieve data and information rapidly. 
B) Achieve data dependence. 
C) Reduce data redundancy. 
D) Improve security. 
A) Retrieve data and information rapidly. 
B) Achieve data dependence. 
C) Reduce data redundancy. 
D) Improve security.

Question 5

Databases store data in single tables to reduce data redundancy.

Accepted Answer

A) True 
 B)False

Question 6

Which statement is false regarding the hierarchical database structure?

Accepted Answer

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. 
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.

Question 7

Which database structure was never widely adopted by business organizations today?

Accepted Answer

A) network 
B) relational 
C) object- oriented 
D) hierarchical 
A) network 
B) relational 
C) object- oriented 
D) hierarchical

Question 8

A flat file is a table that does not have repeating columns.

Accepted Answer

A) True 
 B)False

Question 9

The duties of the DBA fall into all of the following major areas except for:

Accepted Answer

A) database security. 
B) database implementation. 
C) database planning. 
D) performance statistics processor. 
A) database security. 
B) database implementation. 
C) database planning. 
D) performance statistics processor.

Question 10

The__________ was developed to allow retrieval of specific records.

Accepted Answer

network da

Question 11

Which of the following is not a major area for the database administrator?

Accepted Answer

A) security 
B) implementation 
C) programming 
D) planning 
A) security 
B) implementation 
C) programming 
D) planning

Question 12

Which of the following is not a common method for accessing the database held in a database management system?

Accepted Answer

A) reports 
B) forms 
C) queries 
D) tables 
A) reports 
B) forms 
C) queries 
D) tables

Question 13

List the steps that occur for a process- oriented approach to creating a database.

Accepted Answer

1) Define the problem. 
2) Ide

Question 14

A candidate key is a field that does not uniquely identify each table row and can be used as a key.

Accepted Answer

A) True 
 B)False

Question 15

Name the key personnel involved with databases and briefly describe their roles.

Accepted Answer

The database administrator has both tech

Question 16

Relational database structures are based on implicit relationships.

Accepted Answer

A) True 
 B)False

Question 17

The majority of users' interactions with databases are via reports and forms.

Accepted Answer

A) True 
 B)False

Question 18

A__________ is a field that uniquely identifies each table row but that was not chosen to be the key.

Accepted Answer

The answer of A__________ is a field that uniquely identifies...

Question 19

__________is the ability to make changes in the data structure without making changes to the application programs that process the data.

Accepted Answer

The answer of __________is the ability to make changes in...

Question 20

Entity- relationship diagrams are used to describe relationships between conceptual collections of data so that their related records can be joined together.

Accepted Answer

A) True 
 B)False

Exam 6: Database Management Systems

The strength of the enterprise modeling approach is that it addresses problems well.

__________consist of the named class, fields in the class, and actions that act upon the class.

The role of the end user is to maintain a secure database.

Which of the following is not an advantage of using a database management system?

Databases store data in single tables to reduce data redundancy.

Which statement is false regarding the hierarchical database structure?

Which database structure was never widely adopted by business organizations today?

A flat file is a table that does not have repeating columns.

The duties of the DBA fall into all of the following major areas except for:

The__________ was developed to allow retrieval of specific records.

Which of the following is not a major area for the database administrator?

Which of the following is not a common method for accessing the database held in a database management system?

List the steps that occur for a process- oriented approach to creating a database.

A candidate key is a field that does not uniquely identify each table row and can be used as a key.

Name the key personnel involved with databases and briefly describe their roles.

Relational database structures are based on implicit relationships.

The majority of users' interactions with databases are via reports and forms.

A__________ is a field that uniquely identifies each table row but that was not chosen to be the key.

__________is the ability to make changes in the data structure without making changes to the application programs that process the data.

Entity- relationship diagrams are used to describe relationships between conceptual collections of data so that their related records can be joined together.

Introduction to Information Systems

Information Systems for Competitive Advantage

Using Information Technology to Engage in Electronic Commerce

System Users and Developers

Computing and Communications Resources

Systems Development

Information in Action

Information Security

Ethical Implications of Information Technology

Decision Support Systems

Everyday Technology Skills

Web/HTML Project Using Microsoft FrontPage

Web/HTML Project Using Notepad

Web/HTML Student Survey

Web/HTML Book Purchase

Spreadsheet Basics

Spreadsheets with Data Capture - Vacation Choice

Spreadsheets with Data Capture - Movie Ticket Purchase

Database Forms and Reports

Database Queries - Customer Database

Database Queries - Inventory Database

Reports Based on Queries

Filters