Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

In the traditional Systems Development Life Cycle, databases are actually produced during the following phase:
A)Systems Implementation
B)Systems Analysis
C)Systems Design
D)Maintenance
2

In a systems development methodology, the following graphical model should be produced:
A)Data model
B)Process model
C)Environment interaction model
D)All of the above
3

Which one of the following indicates poor data quality?
A)The business rule that an employee must belong to a department is enforced by the database
B)The same supplier is shown with two different addresses in two parts of the database
C)Two similar items have two different prices in the supermarket and in the database
D)New prices in a supermarket are updated in a timely fashion in the database
4

Following a power failure, the database is restored with a wrong price for a data item. This break in data quality was caused by:
A)Ambiguity
B)Lack of reliability
C)Incompleteness
D)Inconsistency
5

Which of the following is not a phase of database development?
A)Physical Database Design
B)Conceptual Data Modeling
C)Logical Database Design
D)DBMS Selection
6

Entity Relationship Diagrams are output from the following phase of Database Development:
A)Physical Database Design
B)Conceptual Data Modeling
C)Logical Database Design
D)Distributed Database Design
7

Which of the following decisions would be part of Physical Database Design?
A)Student data and enrollment data will be stored in two different tables
B)An index file will be created on the last name of students in the Student table
C)The Social Security number will be chosen as the primary key of the Student table
D)Student data and enrollment data will be stored in two different tables at two different locations
8

Which of the following is an advantage of view design and integration over unique conceptual design?
A)It works better for small projects
B)It works better for large projects
C)It allows omitting logical database design
D)It allows omitting physical database design
9

Logical database design takes place during:
A)Systems implementation
B)Systems design
C)Systems design and system implementation
D)Systems analysis
10

A goal of normalization is to:
A)minimize the number of relationships
B)minimize the number of entities
C)minimize the number of tables
D)minimize data redundancy





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 2 > Multiple Choice Quiz