1 | Page
WGU C175 Pre-Assessment Questions
and Answers Latest 2026
What is a broad definition of data? Ans: Raw facts that
are captured on printed or digital media
What are data? Ans: Facts that are collected and stored in
a database system
What is a determining characteristic of unstructured
data? Ans: It does not follow a data model.
Which is true about flat files? Ans: They contain no
internal hierarchical organization.
Which technology has no internal hierarchy? Ans: Flat
files
How were data retrieved before database management
systems? Ans: Sequentially from simple files
In which two ways does a database management system
environment increase effectiveness in working with data?
Ans: - It enables data sharing,
- It permits storage of vast volumes of data.
What is the uniquely identifiable element about which
data can be categorized in an entity-relationship
diagram? Ans: Entity types
© 2025 All rights reserved
, 2 | Page
Which classification is correct for the box marked
"Quantity" in the given entity-relationship diagram? Ans:
Intersection data
Which data classification is an entity? Ans: Event
A salesperson is authorized to sell 12 products; a
product can be sold by 10 salespersons.
Which kind of binary relationship is described in this
example? Ans: Many-to-many
Which three kinds of rules for referential integrity are
provided by modern relational database management
systems? Ans: Insert, Delete, Update
What is an important aspect of "referential integrity"?
Ans: Reference to data in one relation is based on values
in another relation.
Sales data, detailing the customer names, products sold,
and salespersons, is kept in a database.
Which kind of data in this database would qualify as
intersection data related to both the product and
salesperson entities? Ans: Customer names
What is an attribute or group of attributes that uniquely
identify a tuple in a relation? Ans: Primary key
What is necessary for a primary key in one relation of a
database to match with its corresponding foreign key in
© 2025 All rights reserved
WGU C175 Pre-Assessment Questions
and Answers Latest 2026
What is a broad definition of data? Ans: Raw facts that
are captured on printed or digital media
What are data? Ans: Facts that are collected and stored in
a database system
What is a determining characteristic of unstructured
data? Ans: It does not follow a data model.
Which is true about flat files? Ans: They contain no
internal hierarchical organization.
Which technology has no internal hierarchy? Ans: Flat
files
How were data retrieved before database management
systems? Ans: Sequentially from simple files
In which two ways does a database management system
environment increase effectiveness in working with data?
Ans: - It enables data sharing,
- It permits storage of vast volumes of data.
What is the uniquely identifiable element about which
data can be categorized in an entity-relationship
diagram? Ans: Entity types
© 2025 All rights reserved
, 2 | Page
Which classification is correct for the box marked
"Quantity" in the given entity-relationship diagram? Ans:
Intersection data
Which data classification is an entity? Ans: Event
A salesperson is authorized to sell 12 products; a
product can be sold by 10 salespersons.
Which kind of binary relationship is described in this
example? Ans: Many-to-many
Which three kinds of rules for referential integrity are
provided by modern relational database management
systems? Ans: Insert, Delete, Update
What is an important aspect of "referential integrity"?
Ans: Reference to data in one relation is based on values
in another relation.
Sales data, detailing the customer names, products sold,
and salespersons, is kept in a database.
Which kind of data in this database would qualify as
intersection data related to both the product and
salesperson entities? Ans: Customer names
What is an attribute or group of attributes that uniquely
identify a tuple in a relation? Ans: Primary key
What is necessary for a primary key in one relation of a
database to match with its corresponding foreign key in
© 2025 All rights reserved
