WGU D427 DATABASE MANAGEMENT
APPLICATION ACTUAL PRE-
ASSESSMENT AND OBJECTIVE
ASSESSMENT EXAM|LATEST UPDATE
2024-2025|VERIFIED EXAM
QUESTIONS AND CORRECT ANSWERS
ALL GRADED A+|GUARANTEED
SUCCESS
A ____ is a column, or group of columns, used to identify a row. - ANSWER-
✅Primary key
A ____ consists of a single column. - ANSWER-✅Simple primary key
A ____ key consists of multiple columns. - ANSWER-✅Composite primary
All primary keys columns are necessary for uniqueness.
When any column is removed, the resulting simple or composite column is no
longer unique. - ANSWER-✅Minimal
The ____ constraint in the CREATE TABLE statement names the table's ____. The
____ constraint ensures that a column or group of columns is always unique and
non-null. - ANSWER-✅Primary key
An _____ is a numeric column that is assigned an automatically incrementing value
when a new row is inserted. - ANSWER-✅Auto-increment column
The ____ keyword defines an auto-increment column. It follows the column's data
type in a CREATE TABLE statement. - ANSWER-✅AUTO_INCREMENT
A ____ is a column, or group of columns, that refer to a primary key. - ANSWER-
✅Foreign key
____ requires foreign key values must either be NULL or match some value of the
referenced primary key. - ANSWER-✅Referential integrity
,A ____ constraint is added to a CREATE TABLE statement with the ____ and
REFERENCES keywords. - ANSWER-✅Foreign key; references
A ____ foreign key is a simple or composite foreign key in which all columns are
NULL. - ANSWER-✅Fully NULL
____ is a relational rule that requires foreign key values to either be fully NULL or
match some primary key value. - ANSWER-✅Referential integrity
____ rejects an insert, update, or delete that violates referential integrity. -
ANSWER-✅RESTRICT
____ sets invalid foreign keys to NULL. - ANSWER-✅SET NULL
____ sets invalid foreign keys to the foreign key default value. - ANSWER-✅SET
DEFAULT
____ propagates primary key changes to foreign keys. - ANSWER-✅CASCADE
Actions are specified in the optional ____ and ____ clauses of the FOREIGN KEY
constraint. ____ and ____ are followed by either RESTRICT, SET NULL, SET DEFAULT,
or CASCADE. - ANSWER-✅ON UPDATE and ON DELETE
A ____ is a rule that governs allowable values in a database. ____ are based on
relational and business rules, and implemented with special keywords in a CREATE
TABLE statement. The database automatically rejects insert, update, and delete
statements that violate a constraint. - ANSWER-✅Constraint(s)
A ____ appears after the column name and data type in a CREATE TABLE statement.
Column constraints govern values in a single column. - ANSWER-✅Column
constraint
A ____ appears in a separate clause of a CREATE TABLE statement and governs
values in one or more columns. - ANSWER-✅Table constraint
The ____ constraint ensures that values in a column, or group of columns, are
unique. - ANSWER-✅UNIQUE
The ____ constraint specifies an expression on one or more columns of a table. The
constraint is violated when the expression is FALSE and satisfied when the
expression is either TRUE or NULL. - ANSWER-✅CHECK
Table ____ may be names using the optional CONSTRAINT keyword, followed by the
constraint name and declaration. - ANSWER-✅CONSTRAINT
An ____ is a high-level representation of data requirements, ignoring implementing
details. - ANSWER-✅Entity-relationship model
,An ____ is a person, place, product, concept, or activity. - ANSWER-✅Entity
A ____ is a statement about two entities. - ANSWER-✅Relationship
An ____ is a descriptive property of an entity. - ANSWER-✅Attribute
A ____ relates an entity to itself. - ANSWER-✅Reflexive relationship
An ____, commonly called an ER diagram, is a schematic picture of entities,
relationships, and attributes. - ANSWER-✅Entity-relationship diagram (ER diagram)
A ____, also known as a ____ or ____, documents additional detail in text format. -
ANSWER-✅Glossary; data dictionary; repository
An ____ is a set of things. Ex: All employees in a company. - ANSWER-✅Entity type
A ____ is a set of related things. Ex: Employee-Manages-Department is a set of
(employee, department) pairs, where the employee manages the department. -
ANSWER-✅Relationship type
An ____ is a set of values. Ex: All employee salaries. - ANSWER-✅Attribute type
An ____ is an individual thing. Ex: The employee Sam Snead. - ANSWER-✅Entity
instance
A ____ is a statement about entity instances. Ex: "Maria Rodriguez manages Sales.".
- ANSWER-✅Relationship instance
An ____ is an individual value. Ex: The salary $35,000. - ANSWER-✅Attribute
instance
____ develops an entity-relationship model, capturing data requirements while
ignoring implementation details. - ANSWER-✅Analysis
____ converts the entity-relationship model into tables, columns, and keys for a
particular database system. - ANSWER-✅Logical design
____ adds indexes and specifies how tables are organized on storage media. -
ANSWER-✅Physical design
In entity-relationship modeling, ____ refers to maxima and minima of relationships
and attributes. - ANSWER-✅Cardinality
____ is the greatest number of instances of one entity that can relate to a single
instance of another entity. - ANSWER-✅Relationship maximum
, A related entity is ____ when the maximum is one and ____ when the maximum is
many. - ANSWER-✅Singular; plural
____ is the least number of instances of one entity that can relate to a single
instance of another entity. - ANSWER-✅Relationship minimum
A related entity is ____ when the minimum is zero and ____ when the minimum is
one. - ANSWER-✅Optional; required
____ is the greatest number of attribute values that can describe each entity
instance. ____ is usually specified as one (singular) or many (plural). - ANSWER-
✅Attribute maximum
____ is the least number of attribute values that can describe each entity instances.
____ is usually specified as zero (optional) or one (required). - ANSWER-✅Attribute
minimum
Each value of a ____ describes at most one entity instance. - ANSWER-✅Unique
attribute
An ____ is unique, singular, and required. - ANSWER-✅Identifying attribute
____ values correspond one-to-one to, or identify, entity instances. - ANSWER-
✅Identifying Attribute
A ____ has one or more identifying attributes. - ANSWER-✅Strong entity
A ____ does not have an identifying attribute. Instead, a weak entity usually has a
relationship, called an ____, to another entity, called an ____. Cardinality of the
identifying entity is 1(1). - ANSWER-✅Weak entity; identifying relationship;
identifying entity
A ____ is a subset of another entity type, called the supertype entity. - ANSWER-
✅Subtype entity
A supertype entity identifies its subtype entities. The identifying relationship is
called an ____. - ANSWER-✅IsA relationship
____ are entities that have many common attributes and relationships. - ANSWER-
✅Similar entities
A ____ of a supertype entity is a group of mutually exclusive subtype entities. -
ANSWER-✅Partition
Each partition corresponds to an optional ____ of the supertype entity. - ANSWER-
✅Partition attribute
