Practice — DM5-049–060
DM5-049 — Physical Design · Difficult · distinguish
In Chapter 5, what is a canonical data model used to represent?
A. A standardized data-in-motion/message structure exchanged between systems.
B. The complete enterprise logical model for all data at rest.
C. A materialized query result refreshed on a schedule.
D. A normalized operational database schema only.
DM5-050 — Physical Design · Difficult · distinguish
Which statement correctly distinguishes a view from a materialized view?
A. A view stores rows while a materialized view never stores rows.
B. A view is evaluated virtually at query time; a materialized view stores an instantiated result refreshed at predetermined times.
C. Both are always identical to base tables and require no query logic.
D. A materialized view is the same as a surrogate key.
DM5-051 — Physical Design · Standard · apply
A very wide table is split so frequently used columns are stored separately from rarely used columns. Which technique is this?
A. Horizontal partitioning
B. Denormalization
C. Vertical partitioning
D. Generalization
DM5-052 — Physical Design · Standard · apply
A large table is divided by year so different row sets are stored separately. Which technique is this?
A. Vertical partitioning
B. Specialization
C. Canonical modeling
D. Horizontal partitioning
DM5-053 — Physical Design · Difficult · understand
Which statement best reflects Chapter 5's view of denormalization?
A. It is an intentional introduction of redundancy or structural change, often for performance or security, that must be justified because it increases synchronization/error risk.
B. It is always required after third normal form.
C. It eliminates all redundancy and update anomalies.
D. It is only a conceptual modeling technique.
DM5-054 — Normalization · Standard · recall
Which condition is associated with First Normal Form in Chapter 5?
A. Every non-key attribute depends on the entire composite key.
B. A valid primary key, atomic values, and elimination of repeating groups, including resolution of many-to-many structures through associative entities.
C. There are no dependencies between non-key attributes.
D. All overlapping composite candidate-key anomalies are removed.
DM5-055 — Normalization · Standard · recall
What is the key idea of Second Normal Form?
A. Every value must be atomic.
B. No non-key attribute may depend on another non-key attribute.
C. The primary key is minimal and every non-key attribute depends on the complete key rather than only part of a composite key.
D. All join dependencies must be decomposed.
DM5-056 — Normalization · Standard · recall
Which memory rule best summarizes Third Normal Form as presented in Chapter 5?
A. One fact in one place means every table must have one column.
B. Every entity must use a surrogate key.
C. Every relationship must be ternary.
D. Every non-key attribute depends on the key, the whole key, and nothing but the key.
DM5-057 — Normalization · Difficult · understand
When Chapter 5 uses the phrase 'normalized model' without another qualifier, what level does it usually mean?
A. Third Normal Form (3NF)
B. First Normal Form only
C. Boyce-Codd Normal Form only
D. Fifth Normal Form only
DM5-058 — Abstraction · Standard · distinguish
What is generalization in data modeling?
A. Splitting a supertype into subtypes based on distinguishing properties.
B. Moving common attributes and relationships from similar entities into a shared supertype.
C. Adding duplicate columns for performance.
D. Mapping a logical model into a physical DBMS.
DM5-059 — Abstraction · Standard · distinguish
What is specialization in data modeling?
A. Combining subtypes into a common supertype.
B. Removing all subtype distinctions from the model.
C. Creating subtypes to represent distinguishing attributes or relationships while inheriting supertype properties.
D. Generating a surrogate key for each table.
DM5-060 — Activities · Standard · recall
Which set best matches Chapter 5's core modeling deliverables?
A. Only physical tables and indexes
B. Policies, contracts, and audit reports only
C. Servers, networks, and storage devices
D. Diagrams, definitions, issues/outstanding questions, and lineage