WGU C175 – DATA MANAGEMENT FOUNDATIONS
PA EXAM QUESTIONS WITH VERIFIED ANSWERS
What is a general term for data? - ANSWER *Raw facts* which are stored on
printed or digital media
What are data? - ANSWER Facts that are collected and stored in a database
system
What is one characteristic of unstructured data? - ANSWER It doesn't follow a
data model.
Which item represents unstructured data? - ANSWER Training Video Content
Which is true of the following statements about flat files?
- ANSWER They are not hierarchically organized within themselves.
Which technology is not hierarchically organized? - ANSWER Flat files
How were database management system data retrieved before?
- ANSWER In sequential order from plain files
What is the *uniquely identifiable element* about which data can be grouped in
an entity-relationship diagram?
- ANSWER Entity types
Which classification does the box marked "Quantity" in the given entity-
relationship diagram represent? - ANSWER Intersection data
Which classification is an entity? - ANSWER event
, What does the entity-relationship diagram regarding a car rental agency show? -
ANSWER One manufacturer made at least one of the agency's vehicles.
There are 12 products a salesperson is licensed to sell; a product can be sold by
10 salespersons.
Which kind of binary relationship is shown in this example? - ANSWER
Many-to-many
Which relationship does the cardinality on the diagram show? - ANSWER
Many customers to many products
How is the cardinality of the customers misrepresented? - ANSWER There are
lots of customers, but the cardinality indicates one customer.
What is the correct interpretation of modality on the right-hand side of the
relationship? - ANSWER At least zero customers
What is the modality of the product? - ANSWER One or more
What kind of relationship does this diagram illustrate? - ANSWER Unary one-
to-one
What kind of relationship does this diagram illustrate? - ANSWER Unary one-
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 characteristic of "referential integrity"? - ANSWER
*Reference to data in one relation is *based on* values in another relation.*
A foreign key in a table must refer to a valid primary key in another table.
PA EXAM QUESTIONS WITH VERIFIED ANSWERS
What is a general term for data? - ANSWER *Raw facts* which are stored on
printed or digital media
What are data? - ANSWER Facts that are collected and stored in a database
system
What is one characteristic of unstructured data? - ANSWER It doesn't follow a
data model.
Which item represents unstructured data? - ANSWER Training Video Content
Which is true of the following statements about flat files?
- ANSWER They are not hierarchically organized within themselves.
Which technology is not hierarchically organized? - ANSWER Flat files
How were database management system data retrieved before?
- ANSWER In sequential order from plain files
What is the *uniquely identifiable element* about which data can be grouped in
an entity-relationship diagram?
- ANSWER Entity types
Which classification does the box marked "Quantity" in the given entity-
relationship diagram represent? - ANSWER Intersection data
Which classification is an entity? - ANSWER event
, What does the entity-relationship diagram regarding a car rental agency show? -
ANSWER One manufacturer made at least one of the agency's vehicles.
There are 12 products a salesperson is licensed to sell; a product can be sold by
10 salespersons.
Which kind of binary relationship is shown in this example? - ANSWER
Many-to-many
Which relationship does the cardinality on the diagram show? - ANSWER
Many customers to many products
How is the cardinality of the customers misrepresented? - ANSWER There are
lots of customers, but the cardinality indicates one customer.
What is the correct interpretation of modality on the right-hand side of the
relationship? - ANSWER At least zero customers
What is the modality of the product? - ANSWER One or more
What kind of relationship does this diagram illustrate? - ANSWER Unary one-
to-one
What kind of relationship does this diagram illustrate? - ANSWER Unary one-
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 characteristic of "referential integrity"? - ANSWER
*Reference to data in one relation is *based on* values in another relation.*
A foreign key in a table must refer to a valid primary key in another table.
