WGU - D426: Objective Assessment Actual Questions and
Answers|2025 Update| 100% Correct.
.!= - ANSWER-Compares two values for inequality.
.% (Modulo) - ANSWER-Divides one numeric value by another and returns the
integer remainder
.^ - ANSWER-Raises one numeric value to the power of another.
.= - ANSWER-Compares two values for equality.
.ABS(n) (Function) - ANSWER-Returns the absolute value of n. Distance from
zero. Always a positive number or zero.
.Adding and Dropping Constraints - ANSWER-Constraints are added and
dropped with the ALTER TABLE TableName followed by an ADD, DROP, or
CHANGE clause.
.Aggregate - ANSWER-Computes functions over multiple table rows, such as
sum and count.
.Aggregate (Function) - ANSWER-COUNT() counts the number of rows in the set.
MIN() finds the minimum value in the set.
MAX() finds the maximum value in the set.
SUM() sums all the values in the set.
,AVG() computes the arithmetic mean of all the values in the set.
.ALTER TABLE - ANSWER-Statement that adds, deletes, or modifies columns on
an existing table.
.Analysis - ANSWER-__________ develops an entity-relationship model,
capturing data requirements while ignoring implementation details.
.Analysis Phase, Conceptual Design, Entity-Relationship Modeling (Database
Design) - ANSWER-This phase specifies database requirements without regard
to a specific database system. Requirements are represented as entities,
relationships, and attributes. An entity is a person, place, activity, or thing. A
relationship is a link between entities, and an attribute is a descriptive property
of an entity.
.Analysis Steps - ANSWER-1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities
.Application Programming Interface (API) - ANSWER-To simplify the use of SQL
with a general-purpose language, database programs typically use an
____________ _____________ _______________.
.Artificial Key - ANSWER-An __________ _____ is a single-column primary key
created by the database designer when no suitable single-column or composite
primary key exists. Usually artificial key values are integers, generated
, automatically by the database as new rows are inserted to the table. Artificial
keys are stable, simple, and meaningless.
.AS (Alias) - ANSWER-A column name can be replaced with an alias. The alias
follows the column name, separated by an optional AS keyword.
.Attribute - ANSWER-A descriptive property of an entity.
.Attribute Instance - ANSWER-An attribute instance is an individual value.
.Authorization - ANSWER-Many database users should have limited access to
specific tables, columns, or rows of a database. Database systems authorize
individual users to access specific data.
.Auto-Increment - ANSWER-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.
.BETWEEN (Operator) - ANSWER-The ________ operator provides an alternative
way to determine if a value is between two other values.
.BIGINT - ANSWER-8 bytes
Answers|2025 Update| 100% Correct.
.!= - ANSWER-Compares two values for inequality.
.% (Modulo) - ANSWER-Divides one numeric value by another and returns the
integer remainder
.^ - ANSWER-Raises one numeric value to the power of another.
.= - ANSWER-Compares two values for equality.
.ABS(n) (Function) - ANSWER-Returns the absolute value of n. Distance from
zero. Always a positive number or zero.
.Adding and Dropping Constraints - ANSWER-Constraints are added and
dropped with the ALTER TABLE TableName followed by an ADD, DROP, or
CHANGE clause.
.Aggregate - ANSWER-Computes functions over multiple table rows, such as
sum and count.
.Aggregate (Function) - ANSWER-COUNT() counts the number of rows in the set.
MIN() finds the minimum value in the set.
MAX() finds the maximum value in the set.
SUM() sums all the values in the set.
,AVG() computes the arithmetic mean of all the values in the set.
.ALTER TABLE - ANSWER-Statement that adds, deletes, or modifies columns on
an existing table.
.Analysis - ANSWER-__________ develops an entity-relationship model,
capturing data requirements while ignoring implementation details.
.Analysis Phase, Conceptual Design, Entity-Relationship Modeling (Database
Design) - ANSWER-This phase specifies database requirements without regard
to a specific database system. Requirements are represented as entities,
relationships, and attributes. An entity is a person, place, activity, or thing. A
relationship is a link between entities, and an attribute is a descriptive property
of an entity.
.Analysis Steps - ANSWER-1. Discover entities, relationships, and attributes
2. Determine cardinality
3. Distinguish strong and weak entities
4. Create supertype and subtype entities
.Application Programming Interface (API) - ANSWER-To simplify the use of SQL
with a general-purpose language, database programs typically use an
____________ _____________ _______________.
.Artificial Key - ANSWER-An __________ _____ is a single-column primary key
created by the database designer when no suitable single-column or composite
primary key exists. Usually artificial key values are integers, generated
, automatically by the database as new rows are inserted to the table. Artificial
keys are stable, simple, and meaningless.
.AS (Alias) - ANSWER-A column name can be replaced with an alias. The alias
follows the column name, separated by an optional AS keyword.
.Attribute - ANSWER-A descriptive property of an entity.
.Attribute Instance - ANSWER-An attribute instance is an individual value.
.Authorization - ANSWER-Many database users should have limited access to
specific tables, columns, or rows of a database. Database systems authorize
individual users to access specific data.
.Auto-Increment - ANSWER-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.
.BETWEEN (Operator) - ANSWER-The ________ operator provides an alternative
way to determine if a value is between two other values.
.BIGINT - ANSWER-8 bytes
