WGU D431 OBJECTIVE ASSESSMENT EXAM NEWEST 2025
ACTUAL EXAM COMPLETE 100 QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+
MUST BE Minimal, meaning only NECESSARY primary keys may be
involved. In it's minimal stage, if one of these keys is removed it then
becomes no longer unique.
Auto-Increment - - ANS✔️--Database users occasionally make the
following errors when inserting primary keys:
Inserting values for auto-increment primary keys.
Omitting values for primary keys that are not auto-increment columns.
MySQL allows insertion of a specific value to an auto-increment
column. However, overriding auto-increment for a primary key is
usually a mistake.
,Foreign Key - - ANS✔️--Is a column, or group of columns, that refer to a
primary key. An empty circle (○) represents foreign keys in table
diagrams, and an arrow leads to the referenced primary key.
When a ________ _____ constraint is specified, the database rejects
insert, update, and delete statements that violate referential integrity.
Referential integrity requires ________ ____ values must either be NULL
or match some value of the referenced primary key.
RESTRICT - - ANS✔️--________ rejects an insert, update, or delete that
violates referential integrity.
CASCADE - - ANS✔️--Propagates primary key changes to foreign keys.
Constraint - - ANS✔️--A __________ is a rule that governs allowable values
in a database based on relational and business rules.
,UNIQUE (Constraint) - - ANS✔️--The _______ constraint ensures that
values in a column, or group of columns, are NEVER REPEATED.
CHECK (Constraint) - - ANS✔️--The _______ constraint specifies an
expression on one or more columns of a table.
Adding and Dropping Constraints - - ANS✔️--Constraints are added and
dropped with the ALTER TABLE TableName followed by an ADD, DROP,
or CHANGE clause.
BETWEEN (Operator) - - ANS✔️--The ________ operator provides an
alternative way to determine if a value is between two other values.
LIKE (Operator) - - ANS✔️--The _____ operator, when used in a WHERE
clause, matches text against a pattern using the two wildcard
characters % and _.
ORDER BY (Clause) - - ANS✔️--The _____ ___ clause orders selected rows
by one or more columns in ascending (alphabetic or increasing) order.
, The DESC keyword with the ORDER BY clause orders rows in
descending order.
WITH CHECK OPTION - - ANS✔️--When ______ ______ __________ is
specified, the database rejects inserts and updates that do not satisfy
the view query WHERE clause.
Intangible Entity - - ANS✔️--An _____________ entity is documented in the
data model, but not tracked with data in the database. In an ER
diagram, intangible entities are distinguished with special notation,
such as a dashed rectangle or distinct color.
Dependent Entities - - ANS✔️--Weak Entities
Subject Area - - ANS✔️--A group of related entities.
Unified Modeling Language (UML) - - ANS✔️--Commonly used for
software development. Software data structures are similar to
database structures
ACTUAL EXAM COMPLETE 100 QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+
MUST BE Minimal, meaning only NECESSARY primary keys may be
involved. In it's minimal stage, if one of these keys is removed it then
becomes no longer unique.
Auto-Increment - - ANS✔️--Database users occasionally make the
following errors when inserting primary keys:
Inserting values for auto-increment primary keys.
Omitting values for primary keys that are not auto-increment columns.
MySQL allows insertion of a specific value to an auto-increment
column. However, overriding auto-increment for a primary key is
usually a mistake.
,Foreign Key - - ANS✔️--Is a column, or group of columns, that refer to a
primary key. An empty circle (○) represents foreign keys in table
diagrams, and an arrow leads to the referenced primary key.
When a ________ _____ constraint is specified, the database rejects
insert, update, and delete statements that violate referential integrity.
Referential integrity requires ________ ____ values must either be NULL
or match some value of the referenced primary key.
RESTRICT - - ANS✔️--________ rejects an insert, update, or delete that
violates referential integrity.
CASCADE - - ANS✔️--Propagates primary key changes to foreign keys.
Constraint - - ANS✔️--A __________ is a rule that governs allowable values
in a database based on relational and business rules.
,UNIQUE (Constraint) - - ANS✔️--The _______ constraint ensures that
values in a column, or group of columns, are NEVER REPEATED.
CHECK (Constraint) - - ANS✔️--The _______ constraint specifies an
expression on one or more columns of a table.
Adding and Dropping Constraints - - ANS✔️--Constraints are added and
dropped with the ALTER TABLE TableName followed by an ADD, DROP,
or CHANGE clause.
BETWEEN (Operator) - - ANS✔️--The ________ operator provides an
alternative way to determine if a value is between two other values.
LIKE (Operator) - - ANS✔️--The _____ operator, when used in a WHERE
clause, matches text against a pattern using the two wildcard
characters % and _.
ORDER BY (Clause) - - ANS✔️--The _____ ___ clause orders selected rows
by one or more columns in ascending (alphabetic or increasing) order.
, The DESC keyword with the ORDER BY clause orders rows in
descending order.
WITH CHECK OPTION - - ANS✔️--When ______ ______ __________ is
specified, the database rejects inserts and updates that do not satisfy
the view query WHERE clause.
Intangible Entity - - ANS✔️--An _____________ entity is documented in the
data model, but not tracked with data in the database. In an ER
diagram, intangible entities are distinguished with special notation,
such as a dashed rectangle or distinct color.
Dependent Entities - - ANS✔️--Weak Entities
Subject Area - - ANS✔️--A group of related entities.
Unified Modeling Language (UML) - - ANS✔️--Commonly used for
software development. Software data structures are similar to
database structures
