WGU C170 Data Management
Applications OA ACTUAL EXAM
2025/2026 COMPLETE
QUESTIONS WITH CORRECT
DETAILED ANSWERS || 100%
GUARANTEED PASS <BRAND
NEW VERSION>
domain - ANSWER In data modeling, the construct used to
organize and describe an attribute's set of possible values
superkey - ANSWER An attribute or attributes that uniquely
identify each entity in a table. Any composite key with this is
also this.
candidate key - ANSWER A minimal superkey; that is, a key
that does not contain a subset of attributes that is itself a
superkey
entity integrity - ANSWER The property of a relational table
that guarantees each entity has a unique value in a primary key
and that the key has no null values
referential integrity - ANSWER A condition by which a
dependent table's foreign key must have either a null entry or a
matching entry in the related table
data dictionary - ANSWER A DBMS component that stores
metadata. It contains the data definition & their characteristics
and relationships; may also include data external to the DBMS
, system catalog - ANSWER A detailed system data dictionary
that describes all objects in a database
homonym - ANSWER The use of the same name to label
different attributes, much like similar-sounding words with
different meanings
synonym - ANSWER The use of different names to identify the
same object, such as an entity, an attribute, or a relationship.
These should generally be avoided.
not null and unique - ANSWER Any candidate key must have
these two constraints enforced
cardinality - ANSWER Term for how many instances of one
object are related to instances of another object (maximum)
modality - ANSWER Term for whether an instance of a
specific entity is optional or mandatory in a relationship
(minimum)
connectivity - ANSWER Term for the classification of the
relationship between entities. Classifications include 1:1, 1:M,
and M:N
CREATE SCHEMA AUTHORIZATION - ANSWER SQL
command to create a database schema
DEFAULT - ANSWER SQL option to define a default value
for a column (when no value is given)
CHECK - ANSWER SQL command to validate data in an
attribute, used during table column creation
CREATE TABLE AS - ANSWER SQL command to create a
new table based on a query in the user's database schema
,HAVING - ANSWER SQL option that restricts a selection of
grouped rows based on a condition
EXISTS - ANSWER SQL option that checks whether a
subquery returns any rows
DECIMAL - ANSWER SQL data type like the NUMBER
specification, but the storage length is a minimum specification
True - ANSWER True or false: if an INSERT or SELECT
command is embedded inside a program for later use, the
attribute list should always be used, as the table may change
over time
inner join - ANSWER A join operation in which only rows that
meet a given criterion are selected. The most common type of
join
outer join - ANSWER A join operation that produces a table in
which all unmatched pairs are retained; unmatched values in the
related table are left null
cross join - ANSWER A join operation that returns the
Cartesian product of two sets or tables
natural join - ANSWER Join type that returns only the rows
with matching values in the matching columns; the matching
columns must have the same names and similar data types
left, right, full - ANSWER Name the three types of outer joins
ALL - ANSWER This operator can be used to compare
something to every returned row of a subquery
ANY - ANSWER This operator can be used to compare
something to a list of values and return any rows that satisfy the
criteria
, correlated subquery - ANSWER A subquery that executes once
for each row in the outer query
UNION - ANSWER SQL statement that combines rows from
two or more queries without including duplicate rows, as long as
the queries return the same # of attributes and similar data types
UNION ALL - ANSWER SQL statement similar to UNION
but retaining duplicate rows
INTERSECT - ANSWER SQL statement used to combine rows
from two queries, returning only the rows that appear in both
sets
EXCEPT (MINUS) - ANSWER SQL statement that combines
rows from two queries and returns only the rows that appear in
the first set but not in the second
view - ANSWER A virtual table based on a SELECT query that
is saved as an object in the database
base table - ANSWER The table on which a view is based
batch update routine - ANSWER A routine that pools
transactions into a single group to update a master table in a
single operation
updatable view - ANSWER A view that can update attributes in
base tables that are used in the view
True - ANSWER One easy way to determine whether a view
can be used to update a base table is if the primary key columns
of the base table you want to update still have unique values in
the view, then the base table is updatable
Applications OA ACTUAL EXAM
2025/2026 COMPLETE
QUESTIONS WITH CORRECT
DETAILED ANSWERS || 100%
GUARANTEED PASS <BRAND
NEW VERSION>
domain - ANSWER In data modeling, the construct used to
organize and describe an attribute's set of possible values
superkey - ANSWER An attribute or attributes that uniquely
identify each entity in a table. Any composite key with this is
also this.
candidate key - ANSWER A minimal superkey; that is, a key
that does not contain a subset of attributes that is itself a
superkey
entity integrity - ANSWER The property of a relational table
that guarantees each entity has a unique value in a primary key
and that the key has no null values
referential integrity - ANSWER A condition by which a
dependent table's foreign key must have either a null entry or a
matching entry in the related table
data dictionary - ANSWER A DBMS component that stores
metadata. It contains the data definition & their characteristics
and relationships; may also include data external to the DBMS
, system catalog - ANSWER A detailed system data dictionary
that describes all objects in a database
homonym - ANSWER The use of the same name to label
different attributes, much like similar-sounding words with
different meanings
synonym - ANSWER The use of different names to identify the
same object, such as an entity, an attribute, or a relationship.
These should generally be avoided.
not null and unique - ANSWER Any candidate key must have
these two constraints enforced
cardinality - ANSWER Term for how many instances of one
object are related to instances of another object (maximum)
modality - ANSWER Term for whether an instance of a
specific entity is optional or mandatory in a relationship
(minimum)
connectivity - ANSWER Term for the classification of the
relationship between entities. Classifications include 1:1, 1:M,
and M:N
CREATE SCHEMA AUTHORIZATION - ANSWER SQL
command to create a database schema
DEFAULT - ANSWER SQL option to define a default value
for a column (when no value is given)
CHECK - ANSWER SQL command to validate data in an
attribute, used during table column creation
CREATE TABLE AS - ANSWER SQL command to create a
new table based on a query in the user's database schema
,HAVING - ANSWER SQL option that restricts a selection of
grouped rows based on a condition
EXISTS - ANSWER SQL option that checks whether a
subquery returns any rows
DECIMAL - ANSWER SQL data type like the NUMBER
specification, but the storage length is a minimum specification
True - ANSWER True or false: if an INSERT or SELECT
command is embedded inside a program for later use, the
attribute list should always be used, as the table may change
over time
inner join - ANSWER A join operation in which only rows that
meet a given criterion are selected. The most common type of
join
outer join - ANSWER A join operation that produces a table in
which all unmatched pairs are retained; unmatched values in the
related table are left null
cross join - ANSWER A join operation that returns the
Cartesian product of two sets or tables
natural join - ANSWER Join type that returns only the rows
with matching values in the matching columns; the matching
columns must have the same names and similar data types
left, right, full - ANSWER Name the three types of outer joins
ALL - ANSWER This operator can be used to compare
something to every returned row of a subquery
ANY - ANSWER This operator can be used to compare
something to a list of values and return any rows that satisfy the
criteria
, correlated subquery - ANSWER A subquery that executes once
for each row in the outer query
UNION - ANSWER SQL statement that combines rows from
two or more queries without including duplicate rows, as long as
the queries return the same # of attributes and similar data types
UNION ALL - ANSWER SQL statement similar to UNION
but retaining duplicate rows
INTERSECT - ANSWER SQL statement used to combine rows
from two queries, returning only the rows that appear in both
sets
EXCEPT (MINUS) - ANSWER SQL statement that combines
rows from two queries and returns only the rows that appear in
the first set but not in the second
view - ANSWER A virtual table based on a SELECT query that
is saved as an object in the database
base table - ANSWER The table on which a view is based
batch update routine - ANSWER A routine that pools
transactions into a single group to update a master table in a
single operation
updatable view - ANSWER A view that can update attributes in
base tables that are used in the view
True - ANSWER One easy way to determine whether a view
can be used to update a base table is if the primary key columns
of the base table you want to update still have unique values in
the view, then the base table is updatable
