Question 1

Which view of the data in a database shows one record at a time?

Accepted Answer

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

Question 2

Two primary goals of the database concept are to minimize data redundancy and achieve data dependence.

Accepted Answer

A) True 
 B)False  False

Question 3

Data dictionary is the term that refers to the definition of data stored within the database and controlled by the database management system.

Accepted Answer

A) True 
 B)False  True

Question 4

A restrictive definition of a database is the collection of data under the control of database management system software.

Accepted Answer

A) True 
 B)False

Question 5

In the data hierarchy, what is a collection of files?

Accepted Answer

A) database 
B) data field 
C) data 
D) record 
A) database 
B) data field 
C) data 
D) record

Question 6

The database administrator's role of offering educational programs to database users and providing assistance when needed falls into which major area?

Accepted Answer

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

Question 7

Which statement is false concerning database programmers?

Accepted Answer

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

Question 8

Which of the following disadvantages of using a database management system becomes less important with each passing year?

Accepted Answer

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

Question 9

What are the three definitions of a database?

Accepted Answer

A database is a collection of files. The

Question 10

The term that describes conceptual collections of related data fields is a(n):

Accepted Answer

A) entity. 
B) record. 
C) attribute. 
D) field. 
A) entity. 
B) record. 
C) attribute. 
D) field.

Question 11

The logical integration of records across multiple physical locations is called the ___________.

Accepted Answer

The answer of The logical integration of records across multiple...

Question 12

A key in a table is a:

Accepted Answer

A) file. 
B) record. 
C) data field. 
D) data. 
A) file. 
B) record. 
C) data field. 
D) data.

Question 13

Structured query language is the method of choice for interacting with Web- based databases.

Accepted Answer

A) True 
 B)False

Question 14

Briefly explain the three database structures discussed in this chapter.

Accepted Answer

The hierarchical structure is formed by

Question 15

When a manager wants only a few selected records from the very large number of records in the database, the hierarchical structure is inefficient.

Accepted Answer

A) True 
 B)False

Question 16

Which database definition is the collection of data under the control of database management system software?

Accepted Answer

A) general definition of a database 
B) relational database 
C) restrictive definition of a database 
D) database 
A) general definition of a database 
B) relational database 
C) restrictive definition of a database 
D) database

Question 17

In A__________ includes the definitions of the data stored within the database and controlled by the database management system.

Accepted Answer

The answer of In A__________ includes the definitions of the...

Question 18

When changes to the data structure are made without affecting the application programs that process the data, it is referred to as:

Accepted Answer

A) data consistency. 
B) data dependence. 
C) data duplication. 
D) data independence. 
A) data consistency. 
B) data dependence. 
C) data duplication. 
D) data independence.

Question 19

Database planning involves working with business area managers to define the firm's data needs.

Accepted Answer

A) True 
 B)False

Question 20

The database feature that allows data analysis similar to statistical cross- tabulation is:

Accepted Answer

A) data mining. 
B) query. 
C) filtering. 
D) OLAP. 
A) data mining. 
B) query. 
C) filtering. 
D) OLAP.

Exam 6: Database Management Systems

Which view of the data in a database shows one record at a time?

Two primary goals of the database concept are to minimize data redundancy and achieve data dependence.

Data dictionary is the term that refers to the definition of data stored within the database and controlled by the database management system.

A restrictive definition of a database is the collection of data under the control of database management system software.

In the data hierarchy, what is a collection of files?

The database administrator's role of offering educational programs to database users and providing assistance when needed falls into which major area?

Which statement is false concerning database programmers?

Which of the following disadvantages of using a database management system becomes less important with each passing year?

What are the three definitions of a database?

The term that describes conceptual collections of related data fields is a(n):

The logical integration of records across multiple physical locations is called the ___________.

A key in a table is a:

Structured query language is the method of choice for interacting with Web- based databases.

Briefly explain the three database structures discussed in this chapter.

When a manager wants only a few selected records from the very large number of records in the database, the hierarchical structure is inefficient.

Which database definition is the collection of data under the control of database management system software?

In A__________ includes the definitions of the data stored within the database and controlled by the database management system.

When changes to the data structure are made without affecting the application programs that process the data, it is referred to as:

Database planning involves working with business area managers to define the firm's data needs.

The database feature that allows data analysis similar to statistical cross- tabulation is:

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