2
WGU C175 Pre-Assessment questions with verified
|| || || || || ||
detailed answers ||
What is a broad definition of data? - ✔✔Raw facts that are captured on printed or digital
|| || || || || || || || || || || || || || || || ||
media
What are data? - ✔✔Facts that are collected and stored in a database system
|| || || || || || || || || || || || ||
What is a determining characteristic of unstructured data? - ✔✔It does not follow a data
|| || || || || || || || || || || || || || ||
model.
Which is true about flat files? - ✔✔They contain no internal hierarchical organization.
|| || || || || || || || || || || ||
Which technology has no internal hierarchy? - ✔✔Flat files
|| || || || || || || ||
How were data retrieved before database management systems? - ✔✔Sequentially from
|| || || || || || || || || || ||
simple files ||
In which two ways does a database management system environment increase effectiveness
|| || || || || || || || || || || ||
in working with data? - ✔✔- 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? - ✔✔Entity types || || || ||
Which classification is correct for the box marked "Quantity" in the given entity-
|| || || || || || || || || || || ||
relationship diagram? - ✔✔Intersection data || || || ||
, 2
Which data classification is an entity? - ✔✔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? - ✔✔Many-to-many
|| || || || || || || || || || ||
Which three kinds of rules for referential integrity are provided by modern relational
|| || || || || || || || || || || || ||
database management systems? - ✔✔Insert, Delete, Update
|| || || || || ||
What is an important aspect of "referential integrity"? - ✔✔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? - ✔✔Customer names
|| || || || || ||
What is an attribute or group of attributes that uniquely identify a tuple in a relation? -
|| || || || || || || || || || || || || || || || ||
✔✔Primary key ||
What is necessary for a primary key in one relation of a database to match with its
|| || || || || || || || || || || || || || || || ||
corresponding foreign key in another relation of the same database? - ✔✔A domain of
|| || || || || || || || || || || || || ||
values
What uniquely identifies each entity in a collection of entities but is not the primary key? -
|| || || || || || || || || || || || || || || || ||
✔✔The alternate key || ||
WGU C175 Pre-Assessment questions with verified
|| || || || || ||
detailed answers ||
What is a broad definition of data? - ✔✔Raw facts that are captured on printed or digital
|| || || || || || || || || || || || || || || || ||
media
What are data? - ✔✔Facts that are collected and stored in a database system
|| || || || || || || || || || || || ||
What is a determining characteristic of unstructured data? - ✔✔It does not follow a data
|| || || || || || || || || || || || || || ||
model.
Which is true about flat files? - ✔✔They contain no internal hierarchical organization.
|| || || || || || || || || || || ||
Which technology has no internal hierarchy? - ✔✔Flat files
|| || || || || || || ||
How were data retrieved before database management systems? - ✔✔Sequentially from
|| || || || || || || || || || ||
simple files ||
In which two ways does a database management system environment increase effectiveness
|| || || || || || || || || || || ||
in working with data? - ✔✔- 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? - ✔✔Entity types || || || ||
Which classification is correct for the box marked "Quantity" in the given entity-
|| || || || || || || || || || || ||
relationship diagram? - ✔✔Intersection data || || || ||
, 2
Which data classification is an entity? - ✔✔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? - ✔✔Many-to-many
|| || || || || || || || || || ||
Which three kinds of rules for referential integrity are provided by modern relational
|| || || || || || || || || || || || ||
database management systems? - ✔✔Insert, Delete, Update
|| || || || || ||
What is an important aspect of "referential integrity"? - ✔✔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? - ✔✔Customer names
|| || || || || ||
What is an attribute or group of attributes that uniquely identify a tuple in a relation? -
|| || || || || || || || || || || || || || || || ||
✔✔Primary key ||
What is necessary for a primary key in one relation of a database to match with its
|| || || || || || || || || || || || || || || || ||
corresponding foreign key in another relation of the same database? - ✔✔A domain of
|| || || || || || || || || || || || || ||
values
What uniquely identifies each entity in a collection of entities but is not the primary key? -
|| || || || || || || || || || || || || || || || ||
✔✔The alternate key || ||
