Question 1

An output report must have the same fields and in the same order as the database table.

Accepted Answer

A) True 
 B)False  False

Question 2

Output reports may be viewed on the monitor or be printed on a printer.

Accepted Answer

A) True 
 B)False  True

Question 3

Queries build a new table by selecting all or part of the records and/or fields.

Accepted Answer

A) True 
 B)False  True

Question 4

A query uses conditional expressions to select data.

Accepted Answer

A) True 
 B)False

Question 5

First normalization takes care of:

Accepted Answer

A) the insertion anomaly 
B) the update anomaly 
C) the deletion anomaly 
D) the schema 
A) the insertion anomaly 
B) the update anomaly 
C) the deletion anomaly 
D) the schema

Question 6

Forms allow the user to see all of the data for one record at one time on the screen.

Accepted Answer

A) True 
 B)False

Question 7

A key that is a relational field to another table is:

Accepted Answer

A) a primary key 
B) a secondary key 
C) a foreign key 
D) a relational key 
A) a primary key 
B) a secondary key 
C) a foreign key 
D) a relational key

Question 8

An attribute contains entities.

Accepted Answer

A) True 
 B)False

Question 9

The schema:

Accepted Answer

A) Is how the fields are set up in the record. 
B) Is how the records are organized for output. 
C) Shows how the tables are related. 
D) Shows all of the data in a record. 
A) Is how the fields are set up in the record. 
B) Is how the records are organized for output. 
C) Shows how the tables are related. 
D) Shows all of the data in a record.

An output report must have the same fields and in the same order as the database table.

Output reports may be viewed on the monitor or be printed on a printer.

Queries build a new table by selecting all or part of the records and/or fields.

A query uses conditional expressions to select data.

First normalization takes care of:

Forms allow the user to see all of the data for one record at one time on the screen.

A key that is a relational field to another table is:

An attribute contains entities.

The schema:

General Problem-Solving Concepts

Beginning Problem-Solving Concepts for the Computer

Planning Your Solution

An Introduction to Programming Structure

Problem Solving With the Sequential Logic Structure

Problem Solving With Decisions

Problem Solving With Loops

Processing Arrays

Sorting,stacks,and Queues

File Concepts

Linked Lists

Binary Trees

Database Management

Concepts of Object Oriented Programming

Object Oriented Program Design

Introduction to Concepts of Game Development Using Object Oriented Programming

Introduction to Assembly Language

Sequential-Access File Applications

Sequential File Updating

Filters

Exam 14: Relational Database Management Systems

An output report must have the same fields and in the same order as the database table.

Output reports may be viewed on the monitor or be printed on a printer.

Queries build a new table by selecting all or part of the records and/or fields.

A query uses conditional expressions to select data.

First normalization takes care of:

Forms allow the user to see all of the data for one record at one time on the screen.

A key that is a relational field to another table is:

An attribute contains entities.

The schema:

General Problem-Solving Concepts

Beginning Problem-Solving Concepts for the Computer

Planning Your Solution

An Introduction to Programming Structure

Problem Solving With the Sequential Logic Structure

Problem Solving With Decisions

Problem Solving With Loops

Processing Arrays

Sorting,stacks,and Queues

File Concepts

Linked Lists

Binary Trees

Database Management

Concepts of Object Oriented Programming

Object Oriented Program Design

Introduction to Concepts of Game Development Using Object Oriented Programming

Introduction to Assembly Language

Sequential-Access File Applications

Sequential File Updating

Filters