Free 1D0-541 Exam Braindumps
CIW v5 Database Design Specialist

QUESTION: 1
With regard to databases, what is normalization?

A. The process of reducing the cardinality of a relation
B. The process of organizing and refining relations
C. The process of duplicating data to reduce the number of tables
D. The process of limiting data stored in a table to a specific range of values

Answer(s): B
QUESTION: 2
Which three pieces of information did E.F. Codd describe as necessary to retrieve a data
value from a relational database?

A. Attribute, domain, and tuple

B. Entity, relation name, and domain
C. Table name, primary key, and entity
D. Attribute, relation name, and primary key

Answer(s): D
QUESTION: 3
What is a virtual table?

A. A virtual table is a relation created as the result of data manipulation; it exists only in
computer memory, and is not a permanent part of the database.
B. A virtual table is a relation stored in the database; it is used when multiple users
access the same relation in a database.
C. A virtual table is a relation derived from the database data dictionary; it contains
metadata about a base relation. A virtual table is a relation derived from the database?
data dictionary; it contains metadata about a base relation.
D. A virtual table is a relation that consists of primary and foreign keys for a particular set
of relations in a database.

Answer(s): A
QUESTION: 4
Your enterprise has reached the conceptual design phase for a database project. What
is the desired goal at the end of this design phase?

A. A set of normalized relations
B. A reviewed entity-relationship (ER) model
C. An entity-relationship (ER) model with no redundant data
D. A set of denormalized relations

Answer(s): B