WGU D330 DATA SYSTEMS
ADMINISTRATION UPDATED EXAM
QUESTIONS AND CORRECT ANSWERS
●● Hashed Files
Answer: A file that has been encrypted for security purposes.
●● Heap File
Answer: An unsorted set of records.
●● Information
Answer: The transformation of raw data into useful facts.
●● Punch Card
Answer: A card that is perforated and can hold commands or data.
●● Structured Data
Answer: Information with a high degree of organization.
●● Unstructured Data
Answer: Information that does not have structure (such as text)
,●● Binary Relationship
Answer: A relationship between two entity types.
●● Unary Relationship
Answer: An associate occurrence of an entity type with other
occurrences of the same entity type.
●● Cardinality
Answer: The maximum number of entities that can be involved in a
particular relationship.
●● E-R Model
*E-R = Entity - Relationship
Answer: Diagram of entities together with their attributes and the
relationship among them.
●● Intersection Data
Answer: It is data that describes a many-to-many relationship.
●● Modality
, Answer: It is a minimum number of entity occurrences that can be
involved in a relationship.
●● One-to-one Binary Relationship
Answer: 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
Answer: Involves three different entity types.
●● Unique identifier
Answer: It is used to uniquely identify each record in a database table.
●● Attribute
Answer: A property, characteristic, or fact that we know about an entity.
●● "A salesperson works in one office."
What is the name of this relationship?
Answer: One-to-one binary relationship
●● "A salesperson sells to many customers."
ADMINISTRATION UPDATED EXAM
QUESTIONS AND CORRECT ANSWERS
●● Hashed Files
Answer: A file that has been encrypted for security purposes.
●● Heap File
Answer: An unsorted set of records.
●● Information
Answer: The transformation of raw data into useful facts.
●● Punch Card
Answer: A card that is perforated and can hold commands or data.
●● Structured Data
Answer: Information with a high degree of organization.
●● Unstructured Data
Answer: Information that does not have structure (such as text)
,●● Binary Relationship
Answer: A relationship between two entity types.
●● Unary Relationship
Answer: An associate occurrence of an entity type with other
occurrences of the same entity type.
●● Cardinality
Answer: The maximum number of entities that can be involved in a
particular relationship.
●● E-R Model
*E-R = Entity - Relationship
Answer: Diagram of entities together with their attributes and the
relationship among them.
●● Intersection Data
Answer: It is data that describes a many-to-many relationship.
●● Modality
, Answer: It is a minimum number of entity occurrences that can be
involved in a relationship.
●● One-to-one Binary Relationship
Answer: 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
Answer: Involves three different entity types.
●● Unique identifier
Answer: It is used to uniquely identify each record in a database table.
●● Attribute
Answer: A property, characteristic, or fact that we know about an entity.
●● "A salesperson works in one office."
What is the name of this relationship?
Answer: One-to-one binary relationship
●● "A salesperson sells to many customers."
