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