WGU C175 Pre-Assessment
Study online at https://quizlet.com/_4vbm0i
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 It does not follow a data
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 manage- Sequentially from simple
ment systems? files
7. In which two ways does a database management sys- - It enables data sharing,
tem environment increase effectiveness in working - It permits storage of vast
with data? volumes of data.
8. What is the uniquely identifiable element about which Entity types
data can be categorized in an entity-relationship dia-
gram?
9. Which classification is correct for the box marked Intersection data
"Quantity" in the given entity-relationship diagram?
10. Which data classification is an entity? Event
11. A salesperson is authorized to sell 12 products; a prod- Many-to-many
uct can be sold by 10 salespersons.
1/8
, WGU C175 Pre-Assessment
Study online at https://quizlet.com/_4vbm0i
Which kind of binary relationship is described in this
example?
12. Which three kinds of rules for referential integrity are Insert, Delete, Update
provided by modern relational database management
systems?
13. What is an important aspect of "referential integrity"? Reference to data in one
relation is based on values
in another relation.
14. Sales data, detailing the customer names, products Customer names
sold, and salespersons, is kept in a database.
Which kind of data in this database would qualify as in-
tersection data related to both the product and sales-
person entities?
15. What is an attribute or group of attributes that unique- Primary key
ly identify a tuple in a relation?
16. What is necessary for a primary key in one relation of a A domain of values
database to match with its corresponding foreign key
in another relation of the same database?
17. What uniquely identifies each entity in a collection of The alternate key
entities but is not the primary key?
18. What is a term for a set of columns in a table that Candidate key
can uniquely identify any record in that table without
referring to other data?
19. What happens to the original data in database index- It is copied to the index.
ing?
2/8
Study online at https://quizlet.com/_4vbm0i
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 It does not follow a data
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 manage- Sequentially from simple
ment systems? files
7. In which two ways does a database management sys- - It enables data sharing,
tem environment increase effectiveness in working - It permits storage of vast
with data? volumes of data.
8. What is the uniquely identifiable element about which Entity types
data can be categorized in an entity-relationship dia-
gram?
9. Which classification is correct for the box marked Intersection data
"Quantity" in the given entity-relationship diagram?
10. Which data classification is an entity? Event
11. A salesperson is authorized to sell 12 products; a prod- Many-to-many
uct can be sold by 10 salespersons.
1/8
, WGU C175 Pre-Assessment
Study online at https://quizlet.com/_4vbm0i
Which kind of binary relationship is described in this
example?
12. Which three kinds of rules for referential integrity are Insert, Delete, Update
provided by modern relational database management
systems?
13. What is an important aspect of "referential integrity"? Reference to data in one
relation is based on values
in another relation.
14. Sales data, detailing the customer names, products Customer names
sold, and salespersons, is kept in a database.
Which kind of data in this database would qualify as in-
tersection data related to both the product and sales-
person entities?
15. What is an attribute or group of attributes that unique- Primary key
ly identify a tuple in a relation?
16. What is necessary for a primary key in one relation of a A domain of values
database to match with its corresponding foreign key
in another relation of the same database?
17. What uniquely identifies each entity in a collection of The alternate key
entities but is not the primary key?
18. What is a term for a set of columns in a table that Candidate key
can uniquely identify any record in that table without
referring to other data?
19. What happens to the original data in database index- It is copied to the index.
ing?
2/8
