PRE-ASSESSMENT FOR DATA MANAGEMENT –
FOUNDATIONS / STUDY GUIDE QUESTIONS
WITH DEFINITIVE SOLUTIONS
What is a broad definition of data? - Answer: Raw facts that are captured on printed or digital
media
What are data? - Answer: Facts that are collected and stored in a database system
What is a determining characteristic of unstructured data? - Answer: It does not follow a data
model.
Which is true about flat files? - Answer: They contain no internal hierarchical organization.
Which technology has no internal hierarchy? - Answer: Flat files
How were data retrieved before database management systems? - Answer: Sequentially from
simple files
What is the uniquely identifiable element about which data can be categorized in an entity-
relationship diagram? - Answer: Entity types
Which data classification is an entity? - Answer: 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? - Answer: Many-to-many
Which three kinds of rules for referential integrity are provided by modern relational database
management systems? - Answer: Insert, Delete, and Update
What is an important aspect of "referential integrity"? - Answer: Reference to data in one
relation is based on values in another relation.
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? - Answer: 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? - Answer: 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.
FOUNDATIONS / STUDY GUIDE QUESTIONS
WITH DEFINITIVE SOLUTIONS
What is a broad definition of data? - Answer: Raw facts that are captured on printed or digital
media
What are data? - Answer: Facts that are collected and stored in a database system
What is a determining characteristic of unstructured data? - Answer: It does not follow a data
model.
Which is true about flat files? - Answer: They contain no internal hierarchical organization.
Which technology has no internal hierarchy? - Answer: Flat files
How were data retrieved before database management systems? - Answer: Sequentially from
simple files
What is the uniquely identifiable element about which data can be categorized in an entity-
relationship diagram? - Answer: Entity types
Which data classification is an entity? - Answer: 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? - Answer: Many-to-many
Which three kinds of rules for referential integrity are provided by modern relational database
management systems? - Answer: Insert, Delete, and Update
What is an important aspect of "referential integrity"? - Answer: Reference to data in one
relation is based on values in another relation.
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? - Answer: 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? - Answer: 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.
