WGU-C175 UPDATED ACTUAL Exam
Questions and CORRECT Answers
Data - CORRECT ANSWER - Facts gathered together for analysis
1640-Blaise Pascal - CORRECT ANSWER - adding machine similar to odometer
1805-Joseph Marie Jacquard - CORRECT ANSWER - punch card for textile weaving
patterns (Loom)
1833-Charles Babbage - CORRECT ANSWER - loom records patterns in punch cards
1890-Herman Hollerith - CORRECT ANSWER - tabulator/sorter punch cards Amercian
census-ABM
1911-James Powers - CORRECT ANSWER - automatic feeders Powers tabulators
machine comp>UNIVAC>UnisysCorp
1930's - CORRECT ANSWER - Erasable magnetic tape for storage
1940's - CORRECT ANSWER - magnetic drum's begin prototype
Flat Files - CORRECT ANSWER - A file having no internal hierarchy
Hashed Files - CORRECT ANSWER - A file that has been encrypted for security
purposes
Heap Files - CORRECT ANSWER - An unsorted set of records
,Information - CORRECT ANSWER - The transformation of raw data into useful facts
indexed-sequential file - CORRECT ANSWER - an index built over a field
Punch Card - CORRECT ANSWER - A card that is perforated and can hold commands or
data
Structured Data - CORRECT ANSWER - Information with a high degree of organization,
organized in rows and columns
Unstructured Data - CORRECT ANSWER - Information that does not have structure
(such as text) cannot be stored in rows and text such as email, sticky notes, business cards IM's...
Big Data - CORRECT ANSWER - structured and unstructured data, large amount of data
to handle
Digital Data - CORRECT ANSWER - stored as strips of binary numbers
Binary relationship - CORRECT ANSWER - It is a relationship between two entity types.
(simplest relationship)
Cardinality - CORRECT ANSWER - (Means Count) It is the maximum number of entities
that can be involved in a particular relationship ie: one-one, one-many, many-many (Closest to
entity cannot be zero, crows foot)
E-R Model (entity-relationship) - CORRECT ANSWER - It is well named, as it diagrams
entities (together with their attributes) and the relationships among them
, Intersection data - CORRECT ANSWER - It is a data that describes a many-to-many
relationship.
Modality - CORRECT ANSWER - It is a minimum number of entity occurrences that can
be involved in a relationship. (farthest from entity can be zero)
One-to-One Binary Relationship - CORRECT 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.
Simple Linear Index - CORRECT ANSWER - very close in structure to the index in the
back of a book.
Ternary relationship - CORRECT ANSWER - A relationship that involves three different
entity types.
Unary relationship - CORRECT ANSWER - It is an associate occurrence of an entity type
with other occurrences of the same entity type.
Unique identifier - CORRECT ANSWER - It is used to uniquely identify each record in a
database table.
Referential Integrity - CORRECT ANSWER - trying to refer data in one relation in the
DB, data staying the same across tables when you insert/update/delete
Attribute - CORRECT ANSWER - a property of, a characteristic of, or a fact that we
know about an entity
B+ tree index - CORRECT ANSWER - family tree organizational method better to
insert/delete records.
Questions and CORRECT Answers
Data - CORRECT ANSWER - Facts gathered together for analysis
1640-Blaise Pascal - CORRECT ANSWER - adding machine similar to odometer
1805-Joseph Marie Jacquard - CORRECT ANSWER - punch card for textile weaving
patterns (Loom)
1833-Charles Babbage - CORRECT ANSWER - loom records patterns in punch cards
1890-Herman Hollerith - CORRECT ANSWER - tabulator/sorter punch cards Amercian
census-ABM
1911-James Powers - CORRECT ANSWER - automatic feeders Powers tabulators
machine comp>UNIVAC>UnisysCorp
1930's - CORRECT ANSWER - Erasable magnetic tape for storage
1940's - CORRECT ANSWER - magnetic drum's begin prototype
Flat Files - CORRECT ANSWER - A file having no internal hierarchy
Hashed Files - CORRECT ANSWER - A file that has been encrypted for security
purposes
Heap Files - CORRECT ANSWER - An unsorted set of records
,Information - CORRECT ANSWER - The transformation of raw data into useful facts
indexed-sequential file - CORRECT ANSWER - an index built over a field
Punch Card - CORRECT ANSWER - A card that is perforated and can hold commands or
data
Structured Data - CORRECT ANSWER - Information with a high degree of organization,
organized in rows and columns
Unstructured Data - CORRECT ANSWER - Information that does not have structure
(such as text) cannot be stored in rows and text such as email, sticky notes, business cards IM's...
Big Data - CORRECT ANSWER - structured and unstructured data, large amount of data
to handle
Digital Data - CORRECT ANSWER - stored as strips of binary numbers
Binary relationship - CORRECT ANSWER - It is a relationship between two entity types.
(simplest relationship)
Cardinality - CORRECT ANSWER - (Means Count) It is the maximum number of entities
that can be involved in a particular relationship ie: one-one, one-many, many-many (Closest to
entity cannot be zero, crows foot)
E-R Model (entity-relationship) - CORRECT ANSWER - It is well named, as it diagrams
entities (together with their attributes) and the relationships among them
, Intersection data - CORRECT ANSWER - It is a data that describes a many-to-many
relationship.
Modality - CORRECT ANSWER - It is a minimum number of entity occurrences that can
be involved in a relationship. (farthest from entity can be zero)
One-to-One Binary Relationship - CORRECT 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.
Simple Linear Index - CORRECT ANSWER - very close in structure to the index in the
back of a book.
Ternary relationship - CORRECT ANSWER - A relationship that involves three different
entity types.
Unary relationship - CORRECT ANSWER - It is an associate occurrence of an entity type
with other occurrences of the same entity type.
Unique identifier - CORRECT ANSWER - It is used to uniquely identify each record in a
database table.
Referential Integrity - CORRECT ANSWER - trying to refer data in one relation in the
DB, data staying the same across tables when you insert/update/delete
Attribute - CORRECT ANSWER - a property of, a characteristic of, or a fact that we
know about an entity
B+ tree index - CORRECT ANSWER - family tree organizational method better to
insert/delete records.
