2
Data Management Foundation C175 WGU questions with
|| || || || || || ||
verified detailed answers || ||
Associative Entity - ✔✔An associative entity is an element of the entity-relationship model.
|| || || || || || || || || || || || ||
All relationships for the associative entity should be many.
|| || || || || || || ||
Attribute - ✔✔An attribute is a property or characteristic of an entity.
|| || || || || || || || || || ||
Binary relationship - ✔✔A binary relationship is a relationship between two entity types.
|| || || || || || || || || || || ||
Candidate Key - ✔✔Is any column or a combination of columns that can qualify as unique
|| || || || || || || || || || || || || || || ||
key in database.
|| ||
Cardinality - ✔✔Cardinality represents the maximum number of entities that can be
|| || || || || || || || || || || ||
involved in a particular relationship. || || || ||
Cartesian product - ✔✔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 - ✔✔Will delete all records that reference the primary key
|| || || || || || || || || || ||
column subquery - ✔✔Returns a single column of one or more values.
|| || || || || || || || || || ||
data encryption - ✔✔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. || || || || || || || || ||
, 2
Data normalization - ✔✔Is a methodology for organizing attributes into tables so that
|| || || || || || || || || || || || ||
redundancy among the non-key attributes is eliminated. || || || || || ||
Data volatility - ✔✔Describes how often stored data is updated.
|| || || || || || || || ||
Data Volume Assessment - ✔✔Understanding of how much data will be in a database or a
|| || || || || || || || || || || || || || || ||
table within a database
|| || ||
Database - ✔✔A database is a collection of information that is organized so that it can
|| || || || || || || || || || || || || || || ||
easily be accessed, managed, and updated.
|| || || || ||
DCL - ✔✔Data control language is used to control access to data stored in a database.
|| || || || || || || || || || || || || || ||
DDL - ✔✔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 - ✔✔Definer is a MySQL term where AuthID is the same for another DBMS
|| || || || || || || || || || || || || ||
Denormalization - ✔✔The act of duplicating data in a database for performance or the || || || || || || || || || || || || || ||
preservation of historical information || || ||
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.
|| || || || || ||
Data Management Foundation C175 WGU questions with
|| || || || || || ||
verified detailed answers || ||
Associative Entity - ✔✔An associative entity is an element of the entity-relationship model.
|| || || || || || || || || || || || ||
All relationships for the associative entity should be many.
|| || || || || || || ||
Attribute - ✔✔An attribute is a property or characteristic of an entity.
|| || || || || || || || || || ||
Binary relationship - ✔✔A binary relationship is a relationship between two entity types.
|| || || || || || || || || || || ||
Candidate Key - ✔✔Is any column or a combination of columns that can qualify as unique
|| || || || || || || || || || || || || || || ||
key in database.
|| ||
Cardinality - ✔✔Cardinality represents the maximum number of entities that can be
|| || || || || || || || || || || ||
involved in a particular relationship. || || || ||
Cartesian product - ✔✔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 - ✔✔Will delete all records that reference the primary key
|| || || || || || || || || || ||
column subquery - ✔✔Returns a single column of one or more values.
|| || || || || || || || || || ||
data encryption - ✔✔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. || || || || || || || || ||
, 2
Data normalization - ✔✔Is a methodology for organizing attributes into tables so that
|| || || || || || || || || || || || ||
redundancy among the non-key attributes is eliminated. || || || || || ||
Data volatility - ✔✔Describes how often stored data is updated.
|| || || || || || || || ||
Data Volume Assessment - ✔✔Understanding of how much data will be in a database or a
|| || || || || || || || || || || || || || || ||
table within a database
|| || ||
Database - ✔✔A database is a collection of information that is organized so that it can
|| || || || || || || || || || || || || || || ||
easily be accessed, managed, and updated.
|| || || || ||
DCL - ✔✔Data control language is used to control access to data stored in a database.
|| || || || || || || || || || || || || || ||
DDL - ✔✔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 - ✔✔Definer is a MySQL term where AuthID is the same for another DBMS
|| || || || || || || || || || || || || ||
Denormalization - ✔✔The act of duplicating data in a database for performance or the || || || || || || || || || || || || || ||
preservation of historical information || || ||
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.
|| || || || || ||
