©SIRJOEL EXAM SOLUTIONS
10/7/2024 11:03AM
WGU C170 Data Management –
Applications
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)
, ©SIRJOEL EXAM SOLUTIONS
10/7/2024 11:03AM
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
10/7/2024 11:03AM
WGU C170 Data Management –
Applications
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)
, ©SIRJOEL EXAM SOLUTIONS
10/7/2024 11:03AM
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
