WGU C175 - DATA MANAGEMENT FOUNDATIONS| PA|
PRE-ASSESSMENT | QUESTIONS WITH VERIFIED
ANSWERS
What is a broad definition of data? - Answers - *Raw facts* that are captured on printed
or digital media
What are data? - Answers - Facts that are collected and stored in a database system
What is a determining characteristic of unstructured data? - Answers - It does not follow
a data model.
Which item represents unstructured data? - Answers - Training Video Content
Which is true about flat files? - Answers - They contain no internal hierarchical
organization.
Which technology has no internal hierarchy? - Answers - Flat files
How were data retrieved before database management systems? - Answers -
Sequentially from simple files
What is the *uniquely identifiable element* about which data can be categorized in an
entity-relationship diagram? - Answers - Entity types
Which classification is correct for the box marked "Quantity" in the given entity-
relationship diagram? - Answers - Intersection data
Which data classification is an entity? - Answers - event
What is the entity-relationship diagram about a car rental agency showing? - Answers -
One manufacturer created at least one of the agency's cars.
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? - Answers - Many-to-
many
Which relationship does the cardinality in the diagram represent? - Answers - Many
customers to many products
, How is the cardinality of the customers misrepresented? - Answers - There are many
customers, but the cardinality indicates one customer.
What is the correct way to read the modality on the right side of the association? -
Answers - A minimum of zero customers
What is the modality of the product? - Answers - At least one
Which kind of relationship does this diagram depict? - Answers - Unary one-to-one
Which kind of relationship does this diagram depict? - Answers - Unary one-to-many
Which three kinds of rules for *referential integrity* are provided by modern relational
database management systems? - Answers - Insert
Delete
Update
What is an important aspect of "referential integrity"? - Answers - *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.
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? - Answers - WHERE COMMPERCT=15;
Refer to the given SQL statement.
*SELECT COMMPERCT, YEARHIRE*
*FROM SALESPERSON WHERE SPNUM=22;*
How should this statement be altered to retrieve the *entire record* instead of the
commission percentage and year of hire? - Answers - Replace COMMPERCT,
YEARHIRE with an *asterisk*
A manager asks an employee to list attributes of the customers that are headquartered
in Los Angeles and that have a customer number higher than 1000. Refer to the given
SQL statement prepared by this employee.
*SELECT CUSTNUM, CUSTNAME, HQCITY*
*FROM CUSTOMER*
*WHERE HQCITY='Los Angeles'*
PRE-ASSESSMENT | QUESTIONS WITH VERIFIED
ANSWERS
What is a broad definition of data? - Answers - *Raw facts* that are captured on printed
or digital media
What are data? - Answers - Facts that are collected and stored in a database system
What is a determining characteristic of unstructured data? - Answers - It does not follow
a data model.
Which item represents unstructured data? - Answers - Training Video Content
Which is true about flat files? - Answers - They contain no internal hierarchical
organization.
Which technology has no internal hierarchy? - Answers - Flat files
How were data retrieved before database management systems? - Answers -
Sequentially from simple files
What is the *uniquely identifiable element* about which data can be categorized in an
entity-relationship diagram? - Answers - Entity types
Which classification is correct for the box marked "Quantity" in the given entity-
relationship diagram? - Answers - Intersection data
Which data classification is an entity? - Answers - event
What is the entity-relationship diagram about a car rental agency showing? - Answers -
One manufacturer created at least one of the agency's cars.
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? - Answers - Many-to-
many
Which relationship does the cardinality in the diagram represent? - Answers - Many
customers to many products
, How is the cardinality of the customers misrepresented? - Answers - There are many
customers, but the cardinality indicates one customer.
What is the correct way to read the modality on the right side of the association? -
Answers - A minimum of zero customers
What is the modality of the product? - Answers - At least one
Which kind of relationship does this diagram depict? - Answers - Unary one-to-one
Which kind of relationship does this diagram depict? - Answers - Unary one-to-many
Which three kinds of rules for *referential integrity* are provided by modern relational
database management systems? - Answers - Insert
Delete
Update
What is an important aspect of "referential integrity"? - Answers - *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.
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? - Answers - WHERE COMMPERCT=15;
Refer to the given SQL statement.
*SELECT COMMPERCT, YEARHIRE*
*FROM SALESPERSON WHERE SPNUM=22;*
How should this statement be altered to retrieve the *entire record* instead of the
commission percentage and year of hire? - Answers - Replace COMMPERCT,
YEARHIRE with an *asterisk*
A manager asks an employee to list attributes of the customers that are headquartered
in Los Angeles and that have a customer number higher than 1000. Refer to the given
SQL statement prepared by this employee.
*SELECT CUSTNUM, CUSTNAME, HQCITY*
*FROM CUSTOMER*
*WHERE HQCITY='Los Angeles'*
