WGU C175 Data management Home Study
Thorough Review and Complete Answers Ace
your first Attempt Updated 2024/2025
Regression - correct answer predictive - used to map a data item to a real valued
prediction variable
Sequence discovery - correct answer descriptive - discovers sequential patterns
Summarization rules - correct answer descriptive - maps data into subsets with
associated simple descriptions or generalizations.
Time series analysis - correct answer predictive - analysis information over time to
predict future data
* in the select clause - correct answer it indicates that all attributes of the selected row
are to be retrieved.
And operator - correct answer it displays a record if more than one condition is true.
Avg() function - correct answer it returns the average value of a numeric column.
Between operator - correct answer it allows you to specify a range of numeric values in
a search.
Data definition - correct answer 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 - correct answer there are two aspects of data management: data
definition and data manipulation.
, Distinct operator - correct answer it is used to eliminate duplicate rows in a query
result.
In operator - correct answer it allows you to specify a list of character strings to be
included in a search.
Join clause - correct answer it is used to combine rows from more than one table,
based on a common field between them.
Like operator - correct answer it allows you to specify partial character strings in a
"wildcard" sense.
Or operator - correct answer it displays a record if either the first condition or the
second condition is true.
Order by clause - correct answer it simply takes the results of a sql query and orders
them by one or more specified attributes.
Select command - correct answer data retrieval in sql is accomplished with the select
command.
Structured query language - correct answer it is a standard language for data
management in relational databases, known as structured query language or sql.
Subquery - correct answer when one select statement is "nested" within another in a
format, it is known as subquery.
Data - correct answer facts gathered together for analysis
Flat files - correct answer a file having no internal hierarchy
Thorough Review and Complete Answers Ace
your first Attempt Updated 2024/2025
Regression - correct answer predictive - used to map a data item to a real valued
prediction variable
Sequence discovery - correct answer descriptive - discovers sequential patterns
Summarization rules - correct answer descriptive - maps data into subsets with
associated simple descriptions or generalizations.
Time series analysis - correct answer predictive - analysis information over time to
predict future data
* in the select clause - correct answer it indicates that all attributes of the selected row
are to be retrieved.
And operator - correct answer it displays a record if more than one condition is true.
Avg() function - correct answer it returns the average value of a numeric column.
Between operator - correct answer it allows you to specify a range of numeric values in
a search.
Data definition - correct answer 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 - correct answer there are two aspects of data management: data
definition and data manipulation.
, Distinct operator - correct answer it is used to eliminate duplicate rows in a query
result.
In operator - correct answer it allows you to specify a list of character strings to be
included in a search.
Join clause - correct answer it is used to combine rows from more than one table,
based on a common field between them.
Like operator - correct answer it allows you to specify partial character strings in a
"wildcard" sense.
Or operator - correct answer it displays a record if either the first condition or the
second condition is true.
Order by clause - correct answer it simply takes the results of a sql query and orders
them by one or more specified attributes.
Select command - correct answer data retrieval in sql is accomplished with the select
command.
Structured query language - correct answer it is a standard language for data
management in relational databases, known as structured query language or sql.
Subquery - correct answer when one select statement is "nested" within another in a
format, it is known as subquery.
Data - correct answer facts gathered together for analysis
Flat files - correct answer a file having no internal hierarchy
