Pre-Assessment for Data Management –
Foundations Exam actual questions and
CORRECT answers
What is a broad definition of data? - CORRECT ANSWER Raw facts that are captured
on printed or digital media
What are data? - CORRECT ANSWER Facts that are collected and stored in a database
system
What is a determining characteristic of unstructured data? - CORRECT ANSWER It
does not follow a data model.
Which is true about flat files? - CORRECT ANSWER They contain no internal
hierarchical organization.
Which technology has no internal hierarchy? - CORRECT ANSWER Flat files
How were data retrieved before database management systems? - CORRECT
ANSWER Sequentially from simple files
What is the uniquely identifiable element about which data can be categorized in an entity-
relationship diagram? - CORRECT ANSWER Entity types
Which data classification is an entity? - CORRECT 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? - CORRECT
ANSWER Many-to-many
, Which three kinds of rules for referential integrity are provided by modern relational database
management systems? - CORRECT ANSWER Insert, Delete, and Update
What is an important aspect of "referential integrity"? - CORRECT
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? - CORRECT 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? - CORRECT 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.
SELECT CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
Foundations Exam actual questions and
CORRECT answers
What is a broad definition of data? - CORRECT ANSWER Raw facts that are captured
on printed or digital media
What are data? - CORRECT ANSWER Facts that are collected and stored in a database
system
What is a determining characteristic of unstructured data? - CORRECT ANSWER It
does not follow a data model.
Which is true about flat files? - CORRECT ANSWER They contain no internal
hierarchical organization.
Which technology has no internal hierarchy? - CORRECT ANSWER Flat files
How were data retrieved before database management systems? - CORRECT
ANSWER Sequentially from simple files
What is the uniquely identifiable element about which data can be categorized in an entity-
relationship diagram? - CORRECT ANSWER Entity types
Which data classification is an entity? - CORRECT 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? - CORRECT
ANSWER Many-to-many
, Which three kinds of rules for referential integrity are provided by modern relational database
management systems? - CORRECT ANSWER Insert, Delete, and Update
What is an important aspect of "referential integrity"? - CORRECT
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? - CORRECT 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? - CORRECT 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.
SELECT CUSTNUM, CUSTNAME, HQCITY
FROM CUSTOMER
