C175 Data Management Foundation WGU Exam Questions and Answers
with 100% Correct Answers
Associative Entity - (ANSWER)An associative entity is an element of the
entity-relationship model. All relationships for the associative entity should be many.
Attribute - (ANSWER)An attribute is a property or characteristic of an entity.
Binary relationship - (ANSWER)A binary relationship is a relationship between two entity types.
Candidate Key - (ANSWER)Is any column or a combination of columns that can qualify as unique key in
database.
Cardinality - (ANSWER)Cardinality represents the maximum number of entities that can be involved in a
particular relationship.
Cartesian product - (ANSWER)Usually the result of a missing join condition or a method of expanding the
data of 1 table by the number of rows in the second table.
Cascade Delete - (ANSWER)Will delete all records that reference the primary key
column subquery - (ANSWER)Returns a single column of one or more values.
data encryption - (ANSWER)When data is encrypted, it is changed, bit by bit or character by character,
into a form that looks totally garbled. It can and must be reconverted, or decrypted, back to its original
form to be of use.
Data normalization - (ANSWER)Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
, C175 Data Management Foundation WGU Exam Questions and Answers
with 100% Correct Answers
Data volatility - (ANSWER)Describes how often stored data is updated.
Data Volume Assessment - (ANSWER)Understanding of how much data will be in a database or a table
within a database
Database - (ANSWER)A database is a collection of information that is organized so that it can easily be
accessed, managed, and updated.
DCL - (ANSWER)Data control language is used to control access to data stored in a database.
DDL - (ANSWER)Data definition language - 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.
Definer - (ANSWER)Definer is a MySQL term where AuthID is the same for another DBMS
Denormalization - (ANSWER)The act of duplicating data in a database for performance or the
preservation of historical information
disaster recovery - (ANSWER)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 - (ANSWER)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 - (ANSWER)An E-R model is a data model for describing a database in an abstract way.
with 100% Correct Answers
Associative Entity - (ANSWER)An associative entity is an element of the
entity-relationship model. All relationships for the associative entity should be many.
Attribute - (ANSWER)An attribute is a property or characteristic of an entity.
Binary relationship - (ANSWER)A binary relationship is a relationship between two entity types.
Candidate Key - (ANSWER)Is any column or a combination of columns that can qualify as unique key in
database.
Cardinality - (ANSWER)Cardinality represents the maximum number of entities that can be involved in a
particular relationship.
Cartesian product - (ANSWER)Usually the result of a missing join condition or a method of expanding the
data of 1 table by the number of rows in the second table.
Cascade Delete - (ANSWER)Will delete all records that reference the primary key
column subquery - (ANSWER)Returns a single column of one or more values.
data encryption - (ANSWER)When data is encrypted, it is changed, bit by bit or character by character,
into a form that looks totally garbled. It can and must be reconverted, or decrypted, back to its original
form to be of use.
Data normalization - (ANSWER)Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
, C175 Data Management Foundation WGU Exam Questions and Answers
with 100% Correct Answers
Data volatility - (ANSWER)Describes how often stored data is updated.
Data Volume Assessment - (ANSWER)Understanding of how much data will be in a database or a table
within a database
Database - (ANSWER)A database is a collection of information that is organized so that it can easily be
accessed, managed, and updated.
DCL - (ANSWER)Data control language is used to control access to data stored in a database.
DDL - (ANSWER)Data definition language - 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.
Definer - (ANSWER)Definer is a MySQL term where AuthID is the same for another DBMS
Denormalization - (ANSWER)The act of duplicating data in a database for performance or the
preservation of historical information
disaster recovery - (ANSWER)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 - (ANSWER)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 - (ANSWER)An E-R model is a data model for describing a database in an abstract way.
