Pre-Assessment for DATA MANAGEMENT -
FOUNDATIONS
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 categorized
in an entity-relationship diagram?: Entity types
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
1
, 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;
13. 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?: Replace COMMPERCT,
YEARHIRE with an asterisk
14. 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'
Which line should go at the end of this statement?: AND CUSTNUM>1000;
15. What is a key difference between the DISTINCT and ORDER BY statements,
in SQL SELECT commands?: ORDER BY modifies the presentation of data
results and DISTINCT filters data results.
16. Which SQL statement alphabetizes customer names within the same satellite-
office city?: ORDER BY SATCITY, CUSTNAME;
17. The given SQL statement is intended to list the names of the products of
which salesperson Fox has sold more than 500 units.
SELECT PRODNAME
2
FOUNDATIONS
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 categorized
in an entity-relationship diagram?: Entity types
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
1
, 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;
13. 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?: Replace COMMPERCT,
YEARHIRE with an asterisk
14. 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'
Which line should go at the end of this statement?: AND CUSTNUM>1000;
15. What is a key difference between the DISTINCT and ORDER BY statements,
in SQL SELECT commands?: ORDER BY modifies the presentation of data
results and DISTINCT filters data results.
16. Which SQL statement alphabetizes customer names within the same satellite-
office city?: ORDER BY SATCITY, CUSTNAME;
17. The given SQL statement is intended to list the names of the products of
which salesperson Fox has sold more than 500 units.
SELECT PRODNAME
2
