WGU C175 Pre-Assessment questions with |\ |\ |\ |\ |\
answers
What is a broad definition of data? - CORRECT ANSWERS ✔✔Raw
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
facts that are captured on printed or digital media
|\ |\ |\ |\ |\ |\ |\ |\
What are data? - CORRECT ANSWERS ✔✔Facts that are collected
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and stored in a database system
|\ |\ |\ |\ |\
What is a determining characteristic of unstructured data? -
|\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔It does not follow a data model. |\ |\ |\ |\ |\ |\ |\ |\
Which is true about flat files? - CORRECT ANSWERS ✔✔They
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
contain no internal hierarchical organization.|\ |\ |\ |\
Which technology has no internal hierarchy? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Flat files |\ |\
How were data retrieved before database management systems?
|\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Sequentially from simple files
|\ |\ |\ |\ |\ |\ |\
In which two ways does a database management system
|\ |\ |\ |\ |\ |\ |\ |\ |\
environment increase effectiveness in working with data? - |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔- 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? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Entity types |\ |\
Which classification is correct for the box marked "Quantity" in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the given entity-relationship diagram? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\
✔✔Intersection data |\
Which data classification is an entity? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔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? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Many-to-many |\ |\
Which three kinds of rules for referential integrity are provided by
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
modern relational database management systems? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Insert, Delete, Update |\ |\ |\
What is an important aspect of "referential integrity"? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. |\ |\ |\ |\ |\ |\
answers
What is a broad definition of data? - CORRECT ANSWERS ✔✔Raw
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
facts that are captured on printed or digital media
|\ |\ |\ |\ |\ |\ |\ |\
What are data? - CORRECT ANSWERS ✔✔Facts that are collected
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
and stored in a database system
|\ |\ |\ |\ |\
What is a determining characteristic of unstructured data? -
|\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔It does not follow a data model. |\ |\ |\ |\ |\ |\ |\ |\
Which is true about flat files? - CORRECT ANSWERS ✔✔They
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
contain no internal hierarchical organization.|\ |\ |\ |\
Which technology has no internal hierarchy? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Flat files |\ |\
How were data retrieved before database management systems?
|\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Sequentially from simple files
|\ |\ |\ |\ |\ |\ |\
In which two ways does a database management system
|\ |\ |\ |\ |\ |\ |\ |\ |\
environment increase effectiveness in working with data? - |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔- 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? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Entity types |\ |\
Which classification is correct for the box marked "Quantity" in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the given entity-relationship diagram? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\
✔✔Intersection data |\
Which data classification is an entity? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔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? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Many-to-many |\ |\
Which three kinds of rules for referential integrity are provided by
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
modern relational database management systems? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Insert, Delete, Update |\ |\ |\
What is an important aspect of "referential integrity"? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔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. |\ |\ |\ |\ |\ |\
