WGU C175 Study questions with answers
|\ |\ |\ |\ |\
Flat Files - CORRECT ANSWERS ✔✔a file having no internal
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
hierarchy
Hashed Files - CORRECT ANSWERS ✔✔A file that has been
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
encrypted for security purposes. |\ |\ |\
Heap File - CORRECT ANSWERS ✔✔An unsorted set of records.
|\ |\ |\ |\ |\ |\ |\ |\ |\
Information - CORRECT ANSWERS ✔✔The transformation of raw
|\ |\ |\ |\ |\ |\ |\ |\
data into useful facts.
|\ |\ |\
Punch Card - CORRECT ANSWERS ✔✔A card that is perforated
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and can hold commands or data.
|\ |\ |\ |\ |\
Structured Data - CORRECT ANSWERS ✔✔Information with a high
|\ |\ |\ |\ |\ |\ |\ |\
degree of organization.
|\ |\ |\
Unstructured Data - CORRECT ANSWERS ✔✔Information that |\ |\ |\ |\ |\ |\ |\
does not have structure (such as text)
|\ |\ |\ |\ |\ |\
Binary Relationship - CORRECT ANSWERS ✔✔A relationship
|\ |\ |\ |\ |\ |\ |\
between two entity types. |\ |\ |\
,Unary Relationship - CORRECT ANSWERS ✔✔An associate
|\ |\ |\ |\ |\ |\ |\
occurrence of an entity type with other occurrences of the same
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
entity type. |\
Cardinality - CORRECT ANSWERS ✔✔The maximum number of
|\ |\ |\ |\ |\ |\ |\ |\
entities that can be involved in a particular relationship.
|\ |\ |\ |\ |\ |\ |\ |\
E-R Model
|\
*E-R = Entity - Relationship - CORRECT ANSWERS ✔✔Diagram of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
entities together with their attributes and the relationship among
|\ |\ |\ |\ |\ |\ |\ |\ |\
them.
Intersection Data - CORRECT ANSWERS ✔✔It is data that|\ |\ |\ |\ |\ |\ |\ |\ |\
describes a many-to-many relationship.
|\ |\ |\
Modality - CORRECT ANSWERS ✔✔It is a minimum number of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
entity occurrences that can be involved in a relationship.
|\ |\ |\ |\ |\ |\ |\ |\
One-to-one Binary Relationship - CORRECT ANSWERS ✔✔It means
|\ |\ |\ |\ |\ |\ |\
that a single occurrence of one entity type can be associated
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
with a single occurrence of the other entity type and vice versa.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Ternary Relationship - CORRECT ANSWERS ✔✔Involves three
|\ |\ |\ |\ |\ |\ |\
different entity types. |\ |\
, Unique identifier - CORRECT ANSWERS ✔✔It is used to uniquely
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
identify each record in a database table.
|\ |\ |\ |\ |\ |\
Attribute - CORRECT ANSWERS ✔✔A property, characteristic, or
|\ |\ |\ |\ |\ |\ |\ |\
fact that we know about an entity.
|\ |\ |\ |\ |\ |\
"A salesperson works in one office."
|\ |\ |\ |\ |\
What is the name of this relationship? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔One-to-one binary relationship |\ |\
"A salesperson sells to many customers."
|\ |\ |\ |\ |\
What is the name of this relationship? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔One-to-many binary relationship |\ |\
"A salesperson is authorized to sell many products, and a product
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
can be sold by many salespersons."
|\ |\ |\ |\ |\ |\
What is the name of this relationship? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔Many-to-many binary relationship |\ |\
What is the positioning and meaning for Cardinality and Modality
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
on an E-R model? - CORRECT ANSWERS ✔✔Cardinality is the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
outer symbol; represents the maximum.
|\ |\ |\ |\
Modality is the inner symbol; represents the minimum.
|\ |\ |\ |\ |\ |\ |\
|\ |\ |\ |\ |\
Flat Files - CORRECT ANSWERS ✔✔a file having no internal
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
hierarchy
Hashed Files - CORRECT ANSWERS ✔✔A file that has been
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
encrypted for security purposes. |\ |\ |\
Heap File - CORRECT ANSWERS ✔✔An unsorted set of records.
|\ |\ |\ |\ |\ |\ |\ |\ |\
Information - CORRECT ANSWERS ✔✔The transformation of raw
|\ |\ |\ |\ |\ |\ |\ |\
data into useful facts.
|\ |\ |\
Punch Card - CORRECT ANSWERS ✔✔A card that is perforated
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and can hold commands or data.
|\ |\ |\ |\ |\
Structured Data - CORRECT ANSWERS ✔✔Information with a high
|\ |\ |\ |\ |\ |\ |\ |\
degree of organization.
|\ |\ |\
Unstructured Data - CORRECT ANSWERS ✔✔Information that |\ |\ |\ |\ |\ |\ |\
does not have structure (such as text)
|\ |\ |\ |\ |\ |\
Binary Relationship - CORRECT ANSWERS ✔✔A relationship
|\ |\ |\ |\ |\ |\ |\
between two entity types. |\ |\ |\
,Unary Relationship - CORRECT ANSWERS ✔✔An associate
|\ |\ |\ |\ |\ |\ |\
occurrence of an entity type with other occurrences of the same
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
entity type. |\
Cardinality - CORRECT ANSWERS ✔✔The maximum number of
|\ |\ |\ |\ |\ |\ |\ |\
entities that can be involved in a particular relationship.
|\ |\ |\ |\ |\ |\ |\ |\
E-R Model
|\
*E-R = Entity - Relationship - CORRECT ANSWERS ✔✔Diagram of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
entities together with their attributes and the relationship among
|\ |\ |\ |\ |\ |\ |\ |\ |\
them.
Intersection Data - CORRECT ANSWERS ✔✔It is data that|\ |\ |\ |\ |\ |\ |\ |\ |\
describes a many-to-many relationship.
|\ |\ |\
Modality - CORRECT ANSWERS ✔✔It is a minimum number of
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
entity occurrences that can be involved in a relationship.
|\ |\ |\ |\ |\ |\ |\ |\
One-to-one Binary Relationship - CORRECT ANSWERS ✔✔It means
|\ |\ |\ |\ |\ |\ |\
that a single occurrence of one entity type can be associated
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
with a single occurrence of the other entity type and vice versa.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Ternary Relationship - CORRECT ANSWERS ✔✔Involves three
|\ |\ |\ |\ |\ |\ |\
different entity types. |\ |\
, Unique identifier - CORRECT ANSWERS ✔✔It is used to uniquely
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
identify each record in a database table.
|\ |\ |\ |\ |\ |\
Attribute - CORRECT ANSWERS ✔✔A property, characteristic, or
|\ |\ |\ |\ |\ |\ |\ |\
fact that we know about an entity.
|\ |\ |\ |\ |\ |\
"A salesperson works in one office."
|\ |\ |\ |\ |\
What is the name of this relationship? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔One-to-one binary relationship |\ |\
"A salesperson sells to many customers."
|\ |\ |\ |\ |\
What is the name of this relationship? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔One-to-many binary relationship |\ |\
"A salesperson is authorized to sell many products, and a product
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
can be sold by many salespersons."
|\ |\ |\ |\ |\ |\
What is the name of this relationship? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔Many-to-many binary relationship |\ |\
What is the positioning and meaning for Cardinality and Modality
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
on an E-R model? - CORRECT ANSWERS ✔✔Cardinality is the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
outer symbol; represents the maximum.
|\ |\ |\ |\
Modality is the inner symbol; represents the minimum.
|\ |\ |\ |\ |\ |\ |\
