WGU C175 CORE EXAM TEST UPDATED QUESTIONS AND
SOLUTIONS RATED A+
✔✔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
✔✔Unique Identifier - ✔✔A unique identifier is any identifier which is guaranteed to be
unique among all identifiers used for those objects and for a specific purpose.
✔✔Association Rules - ✔✔Descriptive - discovers links or associations amongst data
✔✔Business Intelligence - ✔✔The transformation of raw data into useful information.
✔✔Classification - ✔✔Predictive - maps data into predefined groups or classes
✔✔Clustering - ✔✔Descriptive - groups similar data together into clusters
✔✔Extraction/Transformation/Loading - ✔✔ETL is the process of extracting raw data
and then transforming and loading into a target to be used with Business intelligence.
, ✔✔Regression - ✔✔Predictive - used to map a data item to a real valued prediction
variable
✔✔Sequence Discovery - ✔✔Descriptive - discovers sequential patterns
✔✔Summarization Rules - ✔✔Descriptive - maps data into subsets with associated
simple descriptions or generalizations.
✔✔Time Series Analysis - ✔✔Predictive - analysis information over time to predict
future data
✔✔* in the SELECT clause - ✔✔It indicates that all attributes of the selected row are to
be retrieved.
✔✔AND operator - ✔✔It displays a record if more than one condition is true.
✔✔AVG() function - ✔✔It returns the average value of a numeric column.
✔✔BETWEEN operator - ✔✔It allows you to specify a range of numeric values in a
search.
✔✔Data definition - ✔✔It is operationalized with a data definition language (DDL),
involves instructing the DBMS software on what tables will be in the database, what
attributes will be in the tables, which attributes will be indexed, and so forth.
✔✔Data management - ✔✔There are two aspects of data management: data definition
and data manipulation.
✔✔DISTINCT operator - ✔✔It is used to eliminate duplicate rows in a query result.
✔✔IN operator - ✔✔It allows you to specify a list of character strings to be included in a
search.
✔✔JOIN clause - ✔✔It is used to combine rows from more than one table, based on a
common field between them.
✔✔LIKE operator - ✔✔It allows you to specify partial character strings in a "wildcard"
sense.
✔✔OR operator - ✔✔It displays a record if either the first condition OR the second
condition is true.
✔✔ORDER BY clause - ✔✔It simply takes the results of a SQL query and orders them
by one or more specified attributes.
SOLUTIONS RATED A+
✔✔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
✔✔Unique Identifier - ✔✔A unique identifier is any identifier which is guaranteed to be
unique among all identifiers used for those objects and for a specific purpose.
✔✔Association Rules - ✔✔Descriptive - discovers links or associations amongst data
✔✔Business Intelligence - ✔✔The transformation of raw data into useful information.
✔✔Classification - ✔✔Predictive - maps data into predefined groups or classes
✔✔Clustering - ✔✔Descriptive - groups similar data together into clusters
✔✔Extraction/Transformation/Loading - ✔✔ETL is the process of extracting raw data
and then transforming and loading into a target to be used with Business intelligence.
, ✔✔Regression - ✔✔Predictive - used to map a data item to a real valued prediction
variable
✔✔Sequence Discovery - ✔✔Descriptive - discovers sequential patterns
✔✔Summarization Rules - ✔✔Descriptive - maps data into subsets with associated
simple descriptions or generalizations.
✔✔Time Series Analysis - ✔✔Predictive - analysis information over time to predict
future data
✔✔* in the SELECT clause - ✔✔It indicates that all attributes of the selected row are to
be retrieved.
✔✔AND operator - ✔✔It displays a record if more than one condition is true.
✔✔AVG() function - ✔✔It returns the average value of a numeric column.
✔✔BETWEEN operator - ✔✔It allows you to specify a range of numeric values in a
search.
✔✔Data definition - ✔✔It is operationalized with a data definition language (DDL),
involves instructing the DBMS software on what tables will be in the database, what
attributes will be in the tables, which attributes will be indexed, and so forth.
✔✔Data management - ✔✔There are two aspects of data management: data definition
and data manipulation.
✔✔DISTINCT operator - ✔✔It is used to eliminate duplicate rows in a query result.
✔✔IN operator - ✔✔It allows you to specify a list of character strings to be included in a
search.
✔✔JOIN clause - ✔✔It is used to combine rows from more than one table, based on a
common field between them.
✔✔LIKE operator - ✔✔It allows you to specify partial character strings in a "wildcard"
sense.
✔✔OR operator - ✔✔It displays a record if either the first condition OR the second
condition is true.
✔✔ORDER BY clause - ✔✔It simply takes the results of a SQL query and orders them
by one or more specified attributes.
