WGU C175 Fundamentals of Data
Management Test Exam Review Questions
with all Answers verified for accuracy
Updated 2024/2025
What is called a decomposition process? - correct answer Data normalization
In which of the normal forms should every non-key attribute be fully functionally
dependent on the entire key of a table? - correct answer Second form
What is the correct syntax of the CREATE TABLE command? - correct answer
CREATE TABLE table_name (
column_name data_type(size),
);
What is the correct syntax of the UPDATE command? - correct answer UPDATE
table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
Association Rules - correct answer Association rules specify a relation between
attributes that appears more frequently than expected if the attributes were
independent.
Business Intelligence - correct answer The processes, technologies, and tools needed
to turn data into information, information into knowledge, and knowledge into plans that
drive profitable business action.
Hashed files - correct answer What are files are encrypted using hash functions that
convert data consisting of various formats into numeric values. This allows for faster
data lookup without the use of an index file
, -Improved data sharing
-Improved data security
-Better data integration
-Minimized data inconsistency
-Improved data access
-Improved decision making
-Increased end-user productivity - correct answer What are some advantages of a
DBMS
Operational database, also known as an online transaction processing (OLTP)
database, transactional database, or production database - correct answer What is a
database that is designed primarily to support a company's day-to-day operations
Analytical database - correct answer What type of database focuses primarily on
storing historical data and business metrics used exclusively for tactical or strategic
decision making
Data warehouse, Online analytical processing (OLAP) front end - correct answer What
are the two components of a analytical database
A Field - correct answer What is a character or group of characters (alphabetic or
numeric) that has a specific meaning.
A Record - correct answer What is a logically connected set of one or more fields that
describes a person, place, or thing.
File - correct answer What is a collection of related records
structural independence - correct answer What exists when you can change the file
structure without affecting the application's ability to access the data
Management Test Exam Review Questions
with all Answers verified for accuracy
Updated 2024/2025
What is called a decomposition process? - correct answer Data normalization
In which of the normal forms should every non-key attribute be fully functionally
dependent on the entire key of a table? - correct answer Second form
What is the correct syntax of the CREATE TABLE command? - correct answer
CREATE TABLE table_name (
column_name data_type(size),
);
What is the correct syntax of the UPDATE command? - correct answer UPDATE
table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
Association Rules - correct answer Association rules specify a relation between
attributes that appears more frequently than expected if the attributes were
independent.
Business Intelligence - correct answer The processes, technologies, and tools needed
to turn data into information, information into knowledge, and knowledge into plans that
drive profitable business action.
Hashed files - correct answer What are files are encrypted using hash functions that
convert data consisting of various formats into numeric values. This allows for faster
data lookup without the use of an index file
, -Improved data sharing
-Improved data security
-Better data integration
-Minimized data inconsistency
-Improved data access
-Improved decision making
-Increased end-user productivity - correct answer What are some advantages of a
DBMS
Operational database, also known as an online transaction processing (OLTP)
database, transactional database, or production database - correct answer What is a
database that is designed primarily to support a company's day-to-day operations
Analytical database - correct answer What type of database focuses primarily on
storing historical data and business metrics used exclusively for tactical or strategic
decision making
Data warehouse, Online analytical processing (OLAP) front end - correct answer What
are the two components of a analytical database
A Field - correct answer What is a character or group of characters (alphabetic or
numeric) that has a specific meaning.
A Record - correct answer What is a logically connected set of one or more fields that
describes a person, place, or thing.
File - correct answer What is a collection of related records
structural independence - correct answer What exists when you can change the file
structure without affecting the application's ability to access the data
