Data Management Foundation C175 |||\\\ |||\\\ |||\\\ |||\\\
WGU exam with correct answers |||\\\ |||\\\ |||\\\ |||\\\
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
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
WGU exam with correct answers |||\\\ |||\\\ |||\\\ |||\\\
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
|||\\\ |||\\\ |||\\\ |||\\\ |||\\\ |||\\\
