WGU C175 ACTUAL FINAL PAPER 2026
COMPLETE QUESTIONS AND SOLUTIONS
◍ What are data? Answer: Facts that are collected and stored in a
database system
◍ What is a determining characteristic of unstructured data? Answer:
It does not follow a data model.
◍ Which is true about flat files? Answer: They contain no internal
hierarchical organization.
◍ Which technology has no internal hierarchy? Answer: Flat files
◍ How were data retrieved before database management systems?
Answer: Sequentially from simple files
◍ In which two ways does a database management system
environment increase effectiveness in working with data? Answer: - 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? Answer: Entity types
, ◍ Which classification is correct for the box marked "Quantity" in the
given entity-relationship diagram? Answer: Intersection data
◍ Which data classification is an entity? Answer: 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?
Answer: Many-to-many
◍ Which three kinds of rules for referential integrity are provided by
modern relational database management systems? Answer: Insert,
Delete, Update
◍ What is an important aspect of "referential integrity"? Answer:
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? Answer:
Customer names
COMPLETE QUESTIONS AND SOLUTIONS
◍ What are data? Answer: Facts that are collected and stored in a
database system
◍ What is a determining characteristic of unstructured data? Answer:
It does not follow a data model.
◍ Which is true about flat files? Answer: They contain no internal
hierarchical organization.
◍ Which technology has no internal hierarchy? Answer: Flat files
◍ How were data retrieved before database management systems?
Answer: Sequentially from simple files
◍ In which two ways does a database management system
environment increase effectiveness in working with data? Answer: - 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? Answer: Entity types
, ◍ Which classification is correct for the box marked "Quantity" in the
given entity-relationship diagram? Answer: Intersection data
◍ Which data classification is an entity? Answer: 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?
Answer: Many-to-many
◍ Which three kinds of rules for referential integrity are provided by
modern relational database management systems? Answer: Insert,
Delete, Update
◍ What is an important aspect of "referential integrity"? Answer:
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? Answer:
Customer names
