WGU C175 ACTUAL 2026 STUDY GUIDE QUESTIONS AND
SOLUTIONS RATED A+
✔✔disaster recovery - ✔✔Involves rebuilding an entire information system or significant
parts of one after a catastrophic natural disaster such as a hurricane, tornado,
earthquake, building collapse, or even a major fire.
✔✔DML - ✔✔Data manipulation language refers to the four basic operations that can
and must be performed on data stored in any DBMS: data retrieval, data update,
insertion of new records, and deletion of existing records.
✔✔E-R model - ✔✔An E-R model is a data model for describing a database in an
abstract way.
✔✔embedded mode - ✔✔The SELECT command is embedded within the lines of a
higher-level language program and functions as an input or "read" statement for the
program.
✔✔Entity - ✔✔An entity is an object or event in our environment that we want to keep
track of.
✔✔Foreign Key - ✔✔Is a field (or collection of fields) in one table that uniquely identifies
a row of another table.
✔✔Index - ✔✔Used to help a DBMS find data quickly
✔✔Inner Join - ✔✔Shows row that have matches in both tables
✔✔Intersection Data - ✔✔Intersection Data associated with the concatenation of two
segments.
✔✔Join - ✔✔Joins 2 tables together
✔✔logical view - ✔✔Is a mapping onto a physical table or tables that allows an end
user to access only a specified portion of data.
✔✔Modality - ✔✔Modality represents the minimum number of entity occurrences that
can be involved in a relationship.
✔✔outer join - ✔✔Shows rows in one table that have no match in the other table. Two
kinds of outer joins are left and right joins.
✔✔Primary Key - ✔✔Uniquely identifies each record in the table.
, ✔✔query mode - ✔✔The command goes directly to the relational DBMS, which
evaluates the query and processes it against the database.
✔✔Referential Integrity - ✔✔Referential integrity is a database concept that ensures
that relationships between tables remain consistent.
✔✔referential integrity - ✔✔Enforces rules to guarantee that the foreign key relationship
stays intact with no mismatches.
✔✔Response time - ✔✔Is the delay from the time that the Enter Key is pressed to
execute a query until the result appears on screen.
✔✔Restrict Delete - ✔✔Will not allow deletes if the primary key is referenced
✔✔row subquery - ✔✔Returns a single row of one or more values.
✔✔scalar subquery - ✔✔is the most restrictive subquery because it produces only a
single value
✔✔Set-to-Null on Delete - ✔✔Will set values to null when primary key is deleted
✔✔SQL - ✔✔Is a comprehensive database management language which incorporates
DML and DDL
✔✔subquery - ✔✔One SELECT statement is "nested" within another.
✔✔table subquery - ✔✔Returns a table of one or more rows of one or more columns.
✔✔Ternary Relationship - ✔✔A ternary relationship is when three entities participate in
the relationship.
✔✔Unary Relationships - ✔✔Unary relationships associate occurrences of an entity
type with other occurrences of the same entity type.
✔✔One-to-One Binary Relationship - ✔✔It means that a single occurrence of one entity
type can be associated with a single occurrence of the other entity type and vice versa.
✔✔Throughput - ✔✔Is the measure of how many queries from simultaneous users must
be satisfied in a given period of time by the application set and the database that it
supports.
✔✔UNION - ✔✔To create a result set that combines the results from several queries
SOLUTIONS RATED A+
✔✔disaster recovery - ✔✔Involves rebuilding an entire information system or significant
parts of one after a catastrophic natural disaster such as a hurricane, tornado,
earthquake, building collapse, or even a major fire.
✔✔DML - ✔✔Data manipulation language refers to the four basic operations that can
and must be performed on data stored in any DBMS: data retrieval, data update,
insertion of new records, and deletion of existing records.
✔✔E-R model - ✔✔An E-R model is a data model for describing a database in an
abstract way.
✔✔embedded mode - ✔✔The SELECT command is embedded within the lines of a
higher-level language program and functions as an input or "read" statement for the
program.
✔✔Entity - ✔✔An entity is an object or event in our environment that we want to keep
track of.
✔✔Foreign Key - ✔✔Is a field (or collection of fields) in one table that uniquely identifies
a row of another table.
✔✔Index - ✔✔Used to help a DBMS find data quickly
✔✔Inner Join - ✔✔Shows row that have matches in both tables
✔✔Intersection Data - ✔✔Intersection Data associated with the concatenation of two
segments.
✔✔Join - ✔✔Joins 2 tables together
✔✔logical view - ✔✔Is a mapping onto a physical table or tables that allows an end
user to access only a specified portion of data.
✔✔Modality - ✔✔Modality represents the minimum number of entity occurrences that
can be involved in a relationship.
✔✔outer join - ✔✔Shows rows in one table that have no match in the other table. Two
kinds of outer joins are left and right joins.
✔✔Primary Key - ✔✔Uniquely identifies each record in the table.
, ✔✔query mode - ✔✔The command goes directly to the relational DBMS, which
evaluates the query and processes it against the database.
✔✔Referential Integrity - ✔✔Referential integrity is a database concept that ensures
that relationships between tables remain consistent.
✔✔referential integrity - ✔✔Enforces rules to guarantee that the foreign key relationship
stays intact with no mismatches.
✔✔Response time - ✔✔Is the delay from the time that the Enter Key is pressed to
execute a query until the result appears on screen.
✔✔Restrict Delete - ✔✔Will not allow deletes if the primary key is referenced
✔✔row subquery - ✔✔Returns a single row of one or more values.
✔✔scalar subquery - ✔✔is the most restrictive subquery because it produces only a
single value
✔✔Set-to-Null on Delete - ✔✔Will set values to null when primary key is deleted
✔✔SQL - ✔✔Is a comprehensive database management language which incorporates
DML and DDL
✔✔subquery - ✔✔One SELECT statement is "nested" within another.
✔✔table subquery - ✔✔Returns a table of one or more rows of one or more columns.
✔✔Ternary Relationship - ✔✔A ternary relationship is when three entities participate in
the relationship.
✔✔Unary Relationships - ✔✔Unary relationships associate occurrences of an entity
type with other occurrences of the same entity type.
✔✔One-to-One Binary Relationship - ✔✔It means that a single occurrence of one entity
type can be associated with a single occurrence of the other entity type and vice versa.
✔✔Throughput - ✔✔Is the measure of how many queries from simultaneous users must
be satisfied in a given period of time by the application set and the database that it
supports.
✔✔UNION - ✔✔To create a result set that combines the results from several queries
