WGU C175 PRE-ASSESSMENT FOR DATA
MANAGEMENT FOUNDATIONS EXAM
QUESTIONS AND ANSWERS
1. What is a broad definition of data?: Raw facts that are captured on printed or digital
media
2. What are data?: Facts that are collected and stored in a database system
3. What is a determining characteristic of unstructured data?: It does
not follow a data model.
4. Which is true about flat files?: They contain no internal hierarchical organization.
5. Which technology has no internal hierarchy?: Flat files
6. How were data retrieved before database management systems?:
Sequentially from simple files
7. What is the uniquely identifiable element about which data can
be catego- rized in an entity-relationship diagram?: Entity types
1/
10
, 8. Which data classification is an entity?: Event
9. 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
10. Which three kinds of rules for referential integrity are
provided by modern relational database management systems?: Insert,
Delete, and Update
11. What is an important aspect of "referential integrity"?: Reference to
data in one relation is based on values in another relation.
12. Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find
salespersons with a commission percentage of 15?: WHERE
COMMPERCT=15;
2/
10
MANAGEMENT FOUNDATIONS EXAM
QUESTIONS AND ANSWERS
1. What is a broad definition of data?: Raw facts that are captured on printed or digital
media
2. What are data?: Facts that are collected and stored in a database system
3. What is a determining characteristic of unstructured data?: It does
not follow a data model.
4. Which is true about flat files?: They contain no internal hierarchical organization.
5. Which technology has no internal hierarchy?: Flat files
6. How were data retrieved before database management systems?:
Sequentially from simple files
7. What is the uniquely identifiable element about which data can
be catego- rized in an entity-relationship diagram?: Entity types
1/
10
, 8. Which data classification is an entity?: Event
9. 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
10. Which three kinds of rules for referential integrity are
provided by modern relational database management systems?: Insert,
Delete, and Update
11. What is an important aspect of "referential integrity"?: Reference to
data in one relation is based on values in another relation.
12. Refer to the given SQL statement.
SELECT SPNUM, SPNAME
FROM SALESPERSON
What is the correct line to add to the end of this statement to find
salespersons with a commission percentage of 15?: WHERE
COMMPERCT=15;
2/
10
