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