WGU C175 FINAL+1+2 QUESTIONS WITH 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 In which two ways does a database management system environment increase effectiveness in working with data? CORRECT ANSWER - It enables data sharing, - It permits storage of vast volumes of data. What is the uniquely identifiable element about which data can be categorized in an entity-relationship diagram? CORRECT ANSWER Entity types Which classification is correct for the box marked "Quantity" in the given entity-relationship diagram? CORRECT ANSWER Intersection data 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, Update What is an important aspect of "referential integrity"? CORRECT ANSWER Reference to data in one relation is based on values in another relation.