WGU C170 - Data Management - Applications
Real Questions and Accurate Answers
Collection (A+, verified)
• Associative Entity -✓✓All relationships for the (...) entity should be many.
• Attribute -✓✓An (...) is a property or characteristic of an entity.
• Binary relationship -✓✓A (...) is a relationship between two entity types.
• Cardinality -✓✓(...) represents the maximum number of entities that can be involved in
a particular relationship.
• Cascade Delete -✓✓Will delete all records that reference the primary key
• Database -✓✓A (...) is a collection of information that is organized so that it can easily
be accessed, managed, and updated.
• E-R model -✓✓An (...) is a data model for describing a database in an abstract way.
• Entity -✓✓An (...) is an object or event in our environment that we want to keep track
of.
• Intersection Data -✓✓Associated with the concatenation of two segments
• Modality -✓✓(...) represents the minimum number of entity occurrences that can be
involved in a relationship.
• Ternary Relationship -✓✓A (...) relationship is when three entities participate in the
relationship.
• Unary Relationships -✓✓(...) relationships associate occurrences of an entity type with
other occurrences of the same entity type.
• Unique Identifier -✓✓A (...) is any identifier which is guaranteed to be unique among all
identifiers used for those objects and for a specific purpose.
• Data encryption -✓✓When data is (...), 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 -✓✓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
• 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
• Index -✓✓Used to help a DBMS find data quickly
• Logical view -✓✓Is a mapping onto a physical table or tables that allows an end user
to access only a specified portion of data.
• Response time -✓✓Is the delay from the time that the Enter Key is pressed to execute
a query until the result appears on screen.
• Throughput -✓✓Is the measure of how many queries from simultaneous users must be
satisfied in a given period of time by the application set and the database that it
supports.
• Client/server architecture -✓✓(...) architecture is a network architecture in which the
server manages services consumed by the client. It is also known as two-tier
architecture.
• Database directory -✓✓(...) is an organized repository of databases that stores
attributes such as the database character set and collation.
• GUI (graphical user interface) -✓✓(...) is a computer program that enables a user to
communicate with a computer through the use of graphical icons.
• MySQL -✓✓(...) is an open source RDBMS based on SQL (structure query language)
and used for adding, removing, and modifying information in the database.
• Option file -✓✓(...) is an appropriate way of specifying commonly used options on the
command line while executing a program.
Real Questions and Accurate Answers
Collection (A+, verified)
• Associative Entity -✓✓All relationships for the (...) entity should be many.
• Attribute -✓✓An (...) is a property or characteristic of an entity.
• Binary relationship -✓✓A (...) is a relationship between two entity types.
• Cardinality -✓✓(...) represents the maximum number of entities that can be involved in
a particular relationship.
• Cascade Delete -✓✓Will delete all records that reference the primary key
• Database -✓✓A (...) is a collection of information that is organized so that it can easily
be accessed, managed, and updated.
• E-R model -✓✓An (...) is a data model for describing a database in an abstract way.
• Entity -✓✓An (...) is an object or event in our environment that we want to keep track
of.
• Intersection Data -✓✓Associated with the concatenation of two segments
• Modality -✓✓(...) represents the minimum number of entity occurrences that can be
involved in a relationship.
• Ternary Relationship -✓✓A (...) relationship is when three entities participate in the
relationship.
• Unary Relationships -✓✓(...) relationships associate occurrences of an entity type with
other occurrences of the same entity type.
• Unique Identifier -✓✓A (...) is any identifier which is guaranteed to be unique among all
identifiers used for those objects and for a specific purpose.
• Data encryption -✓✓When data is (...), 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 -✓✓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
• 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
• Index -✓✓Used to help a DBMS find data quickly
• Logical view -✓✓Is a mapping onto a physical table or tables that allows an end user
to access only a specified portion of data.
• Response time -✓✓Is the delay from the time that the Enter Key is pressed to execute
a query until the result appears on screen.
• Throughput -✓✓Is the measure of how many queries from simultaneous users must be
satisfied in a given period of time by the application set and the database that it
supports.
• Client/server architecture -✓✓(...) architecture is a network architecture in which the
server manages services consumed by the client. It is also known as two-tier
architecture.
• Database directory -✓✓(...) is an organized repository of databases that stores
attributes such as the database character set and collation.
• GUI (graphical user interface) -✓✓(...) is a computer program that enables a user to
communicate with a computer through the use of graphical icons.
• MySQL -✓✓(...) is an open source RDBMS based on SQL (structure query language)
and used for adding, removing, and modifying information in the database.
• Option file -✓✓(...) is an appropriate way of specifying commonly used options on the
command line while executing a program.
