Question 1

Structured query language is presented as a standardized form that the user completes to generate a query.

Accepted Answer

A) True 
 B)False

Question 2

One of the disadvantages of having a database management system is that a specialized database management staff must be hired and maintained.

Accepted Answer

A) True 
 B)False

Question 3

Databases reduce in__________ tables.

Accepted Answer

The answer of Databases reduce in__________ tables....

Question 4

Which statement is false concerning the enterprise modeling approach?

Accepted Answer

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

Question 5

Sometimes tables that originally stand alone as independent may later be required to be joined.

Accepted Answer

A) True 
 B)False

Question 6

The network database structure allows the retrieval of specific records with a given record to point to any other record in the database.

Accepted Answer

A) True 
 B)False

Question 7

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.

Accepted Answer

A) True 
 B)False

Question 8

The term used to describe a request for the database to display selected records is:

Accepted Answer

A) question. 
B) query. 
C) sort. 
D) filter. 
A) question. 
B) query. 
C) sort. 
D) filter.

Question 9

__________relationships can be implied from the data.

Accepted Answer

The answer of __________relationships can be implied from the data....

Question 10

Which database feature can be used to limit a user's access to data in the database?

Accepted Answer

A) sorting 
B) OLAP 
C) queries 
D) filtering 
A) sorting 
B) OLAP 
C) queries 
D) filtering

Question 11

Subforms help to enforce the accuracy and consistency that databases require.

Accepted Answer

A) True 
 B)False

Question 12

A record is a collection of data files.

Accepted Answer

A) True 
 B)False

Question 13

In practice, entity- relationship diagrams are developed after the database has been created.

Accepted Answer

A) True 
 B)False

Question 14

__________are aggregated data from the database that are formatted in a manner that aids decision making.

Accepted Answer

The answer of __________are aggregated data from the database that...

Question 15

A__________ is a collection of files.

Accepted Answer

The answer of A__________ is a collection of files....

Question 16

Which of the following is not a step in the problem- oriented approach to creating a database?

Accepted Answer

A) Describe information needs. 
B) Define the problem. 
C) Create an enterprise data model. 
D) Specify data needs. 
A) Describe information needs. 
B) Define the problem. 
C) Create an enterprise data model. 
D) Specify data needs.

Question 17

When databases break information into multiple tables to avoid duplicate data, it is referred to as reducing:

Accepted Answer

A) data accuracy. 
B) data consistency. 
C) data redundancy. 
D) data duplication. 
A) data accuracy. 
B) data consistency. 
C) data redundancy. 
D) data duplication.

Question 18

When defining a database in Microsoft Access, what property is used to force certain characters to be entered in a particular manner?

Accepted Answer

A) validation rule 
B) default value 
C) input mask 
D) key field 
A) validation rule 
B) default value 
C) input mask 
D) key field

Question 19

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:

Accepted Answer

A) data dictionary. 
B) database repository. 
C) database concept. 
D) database dictionary. 
A) data dictionary. 
B) database repository. 
C) database concept. 
D) database dictionary.

Exam 6: Database Management Systems

Structured query language is presented as a standardized form that the user completes to generate a query.

One of the disadvantages of having a database management system is that a specialized database management staff must be hired and maintained.

Databases reduce in__________ tables.

Which statement is false concerning the enterprise modeling approach?

Sometimes tables that originally stand alone as independent may later be required to be joined.

The network database structure allows the retrieval of specific records with a given record to point to any other record in the database.

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.

The term used to describe a request for the database to display selected records is:

__________relationships can be implied from the data.

Which database feature can be used to limit a user's access to data in the database?

Subforms help to enforce the accuracy and consistency that databases require.

A record is a collection of data files.

In practice, entity- relationship diagrams are developed after the database has been created.

__________are aggregated data from the database that are formatted in a manner that aids decision making.

A__________ is a collection of files.

Which of the following is not a step in the problem- oriented approach to creating a database?

When databases break information into multiple tables to avoid duplicate data, it is referred to as reducing:

When defining a database in Microsoft Access, what property is used to force certain characters to be entered in a particular manner?

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:

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