WGU C170 TERMS QUESTIONS & ANSWERS
Associative Entity - Answer -All relationships for the (...) entity should be many.
Attribute - Answer -An (...) is a property or characteristic of an entity.
Binary relationship - Answer -A (...) is a relationship between two entity types.
Cardinality - Answer -(...) represents the maximum number of entities that can be
involved in a particular relationship.
Cascade Delete - Answer -Will delete all records that reference the primary key
Database - Answer -A (...) is a collection of information that is organized so that it can
easily be accessed, managed, and updated.
E-R model - Answer -An (...) is a data model for describing a database in an abstract
way.
Entity - Answer -An (...) is an object or event in our environment that we want to keep
track of.
Intersection Data - Answer -Associated with the concatenation of two segments
Modality - Answer -(...) represents the minimum number of entity occurrences that can
be involved in a relationship.
Ternary Relationship - Answer -A (...) relationship is when three entities participate in
the relationship.
Unary Relationships - Answer -(...) relationships associate occurrences of an entity
type with other occurrences of the same entity type.
Unique Identifier - Answer -A (...) is any identifier which is guaranteed to be unique
among all identifiers used for those objects and for a specific purpose.
Data encryption - Answer -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 - Answer -Is a methodology for organizing attributes into tables so
that redundancy among the non-key attributes is eliminated.
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
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
Index - Answer -Used to help a DBMS find data quickly
Logical view - Answer -Is a mapping onto a physical table or tables that allows an end
user to access only a specified portion of data.
Response time - Answer -Is the delay from the time that the Enter Key is pressed to
execute a query until the result appears on screen.
Throughput - Answer -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 - Answer -(...) 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 - Answer -(...) is an organized repository of databases that stores
attributes such as the database character set and collation.
GUI (graphical user interface) - Answer -(...) is a computer program that enables a user
to communicate with a computer through the use of graphical icons.
MySQL - Answer -(...) is an open source RDBMS based on SQL (structure query
language) and used for adding, removing, and modifying information in the database.
Option file - Answer -(...) is an appropriate way of specifying commonly used options on
the command line while executing a program.
RDBMS (relational database management system) - Answer -(...) is a program that lets
you create, update, and administer a relational database.
Schema - Answer -In a relational database, a (...) defines tables, fields in each table,
and relationships between fields and tables.
DB2 - Answer -(...) is a relational database management system product from IBM that
serves a number of operating system platforms.
Associative Entity - Answer -All relationships for the (...) entity should be many.
Attribute - Answer -An (...) is a property or characteristic of an entity.
Binary relationship - Answer -A (...) is a relationship between two entity types.
Cardinality - Answer -(...) represents the maximum number of entities that can be
involved in a particular relationship.
Cascade Delete - Answer -Will delete all records that reference the primary key
Database - Answer -A (...) is a collection of information that is organized so that it can
easily be accessed, managed, and updated.
E-R model - Answer -An (...) is a data model for describing a database in an abstract
way.
Entity - Answer -An (...) is an object or event in our environment that we want to keep
track of.
Intersection Data - Answer -Associated with the concatenation of two segments
Modality - Answer -(...) represents the minimum number of entity occurrences that can
be involved in a relationship.
Ternary Relationship - Answer -A (...) relationship is when three entities participate in
the relationship.
Unary Relationships - Answer -(...) relationships associate occurrences of an entity
type with other occurrences of the same entity type.
Unique Identifier - Answer -A (...) is any identifier which is guaranteed to be unique
among all identifiers used for those objects and for a specific purpose.
Data encryption - Answer -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 - Answer -Is a methodology for organizing attributes into tables so
that redundancy among the non-key attributes is eliminated.
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
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
Index - Answer -Used to help a DBMS find data quickly
Logical view - Answer -Is a mapping onto a physical table or tables that allows an end
user to access only a specified portion of data.
Response time - Answer -Is the delay from the time that the Enter Key is pressed to
execute a query until the result appears on screen.
Throughput - Answer -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 - Answer -(...) 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 - Answer -(...) is an organized repository of databases that stores
attributes such as the database character set and collation.
GUI (graphical user interface) - Answer -(...) is a computer program that enables a user
to communicate with a computer through the use of graphical icons.
MySQL - Answer -(...) is an open source RDBMS based on SQL (structure query
language) and used for adding, removing, and modifying information in the database.
Option file - Answer -(...) is an appropriate way of specifying commonly used options on
the command line while executing a program.
RDBMS (relational database management system) - Answer -(...) is a program that lets
you create, update, and administer a relational database.
Schema - Answer -In a relational database, a (...) defines tables, fields in each table,
and relationships between fields and tables.
DB2 - Answer -(...) is a relational database management system product from IBM that
serves a number of operating system platforms.
