Question 1

A good application for a RDBMS is:

Accepted Answer

A) Costing a project. 
B) CD collection organization. 
C) An English report. 
D) Calculating a grade average. 
A) Costing a project. 
B) CD collection organization. 
C) An English report. 
D) Calculating a grade average. B

Question 2

A query uses conditional expressions to select data.

Accepted Answer

A) True 
 B)False  True

Question 3

A RDBMS is a relational database since it has a relational field relating two or more tables.

Accepted Answer

A) True 
 B)False  True

Question 4

When designing a RDBMS:

Accepted Answer

A) You should start with the needed output reports. 
B) You should start with the design of the records. 
C) You should start with the division of data into separate tables. 
D) You should start with a list of all the data that will be entered into the records. 
A) You should start with the needed output reports. 
B) You should start with the design of the records. 
C) You should start with the division of data into separate tables. 
D) You should start with a list of all the data that will be entered into the records.

Question 5

The schema of a RDBMS

Accepted Answer

A) Divides the fields into interrelated tables. 
B) Shows the relationship between tables. 
C) Describes the output reports. 
D) Allows the user to enter data into the data tables. 
A) Divides the fields into interrelated tables. 
B) Shows the relationship between tables. 
C) Describes the output reports. 
D) Allows the user to enter data into the data tables.

Question 6

The output reports:

Accepted Answer

A) Should print all fields in a record. 
B) Should print only relevant fields from a record. 
C) Should print all records from the table. 
D) None of the above. 
A) Should print all fields in a record. 
B) Should print only relevant fields from a record. 
C) Should print all records from the table. 
D) None of the above.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The relational field:

Accepted Answer

A) Does not have to have the same name in both tables. 
B) Must have the same name in both tables. 
C) Must be unique in both tables. 
D) Is not necessary to relate two tables in a DBMS. 
A) Does not have to have the same name in both tables. 
B) Must have the same name in both tables. 
C) Must be unique in both tables. 
D) Is not necessary to relate two tables in a DBMS.

Question 9

Second 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 10

Part(s)of a RDBMS include:

Accepted Answer

A) Data tables. 
B) Reports. 
C) Query tables. 
D) All of the above. 
E) None of the above. 
A) Data tables. 
B) Reports. 
C) Query tables. 
D) All of the above. 
E) None of the above.

A good application for a RDBMS is:

A query uses conditional expressions to select data.

A RDBMS is a relational database since it has a relational field relating two or more tables.

When designing a RDBMS:

The schema of a RDBMS

The output reports:

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

The relational field:

Second normalization takes care of:

Part(s)of a RDBMS include:

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

Relational Database Management Systems

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 13: Database Management

A good application for a RDBMS is:

A query uses conditional expressions to select data.

A RDBMS is a relational database since it has a relational field relating two or more tables.

When designing a RDBMS:

The schema of a RDBMS

The output reports:

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

The relational field:

Second normalization takes care of:

Part(s)of a RDBMS include:

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

Relational Database Management Systems

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