INFO 3233 QUESTIONS AND VERIFIED ANSWERS

INFO 3233 QUESTIONS AND VERIFIED ANSWERS


When one uses the term "database design," that term refers to design of which aspect
of the DBMS?

A. The DBMS system
B. The DBMS software
C. The metadata
D. The database structure - Answers - D. The database structure

How does data redundancy foster abnormal conditions in the database?

A. By duplicating efforts for designing the database
B. By forcing database administrators to change values in multiple locations
C. By relying on the integrity of data
D. By creating two entries for all new data - Answers - B. By forcing database
administrators to change values in multiple locations

Why is the selection of proper field names important?

A. Because the file structure becomes self-documenting
B. Because record names depend on field names
C. Because it promotes inconsistencies between departments
D. Because standards exist and must be followed - Answers - A. Because the file
structure becomes self-documenting

_________________ yields a horizontal subset of a table.

A. DIFFERENT
B. PROJECT
C. SELECT
D. PRODUCT - Answers - C. SELECT

The real power behind a relational database, allowing the use of independent tables
linked by common attributes is _________________.

A. INTERJECT
B. SELECT
C. JOIN
D. PROJECT - Answers - C. JOIN

PRODUCT produces a list of all possible pairs of _______________ from two tables.

A. rows