1 | P a g e WGU C175 - D426 DATA MANAGEMENT FOUNDATIONS OA EXAM REAL EXAM 2 LATEST VERSION 2024 ALL 300 QUESTIONS AND CORRECT VERIFIED ANSWERS WITH RATIONALES (LATEST ANSWERS ) (NEW!!) VERSION 1 What is a broad definition of data? A) Numbers that are captured on digital media B) Raw facts that are captured on printed or digital media C) Alphanumeric combinations that can be captured on media that a computer can read D) Any information that can be transferred from print to digital Raw facts that are captured on printed or digital media What are data? A) Facts that have been organized in a meaningful way B) Facts that are the result of a query of a database system C) Facts that are collected and stored in a database system D) Facts that have been processed and used for decision making Facts that are col lected and stored in a database system What is a determining characteristic of unstructured data? A) It does not allow copying and pasting. B) It is easy to query and retrieve by business applications. C) It does not follow a data model. D) It is stored in rows and columns. It does not follow a data model. 2 | P a g e Which is true about flat files? A) They contain no internal hierarchical organization. B) They have a limit of 256 records. C) They can only contain two -dimensional data. D) They are always encrypted. They contain no internal hierarchical organization. Which technology has no internal hierarchy? A) Flat files B) Heap files C) Hashed tables D) Relational databases Flat files How were data retrieved before database management systems? A) Randomly from linked files B) Sequentially from simple files C) Using set operations on complex files D) Using relationships between logical entities Sequentially from simple files In which two ways does a database management system environment increase effectiveness in worki ng with data? A) It enables data sharing. B) It duplicates redundant data for security. C) It permits storage of vast volumes of data. D) It increases the complexity rules by which data is organized. It enables data sharing. It permits storage of vast volu mes of data. 3 | P a g e What is the uniquely identifiable element about which data can be categorized in an entity -relationship diagram? A) Entity types B) Primary keys C) Unary relationships D) Intersection data points Entity types Which classification is correct fo r the box marked "Quantity" in the given entity -
relationship diagram? A) Quantity data B) Modality data C) Intersection data D) Product sales data Intersection data Which data classification is an entity? A) Event B) Duration C) Directions D) Attendance 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? A) One -to-one B) One -to-many C) Many -to-many D) Associative 4 | P a g e Many -to-many Which three kinds of ru les for referential integrity are provided by modern relational database management systems? A) Sort B) Insert C) Query D) Delete E) Update F) Retrieve Insert, Delete, Update What is an important aspect of "referential integrity"? A) Primary keys refer to data in particular relation. B) Reference points are placed by the database in each record during backups. C) The relationships between entities and attributes are called referrals. D) Reference to data in one relation is based on values in another relatio n. Reference to data in one relation is based on values in another relation. Sales data, detailing the customer names, products sold, and salespersons, is kept in a database. The Entity -Relationship (E -R) model is _____. a) a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) b) an alternative to indexing and hashing as a means for providing direct access in files c) a diagramming technique that describes entities, their attributes, and the relationships between them
relationship diagram? A) Quantity data B) Modality data C) Intersection data D) Product sales data Intersection data Which data classification is an entity? A) Event B) Duration C) Directions D) Attendance 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? A) One -to-one B) One -to-many C) Many -to-many D) Associative 4 | P a g e Many -to-many Which three kinds of ru les for referential integrity are provided by modern relational database management systems? A) Sort B) Insert C) Query D) Delete E) Update F) Retrieve Insert, Delete, Update What is an important aspect of "referential integrity"? A) Primary keys refer to data in particular relation. B) Reference points are placed by the database in each record during backups. C) The relationships between entities and attributes are called referrals. D) Reference to data in one relation is based on values in another relatio n. Reference to data in one relation is based on values in another relation. Sales data, detailing the customer names, products sold, and salespersons, is kept in a database. The Entity -Relationship (E -R) model is _____. a) a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) b) an alternative to indexing and hashing as a means for providing direct access in files c) a diagramming technique that describes entities, their attributes, and the relationships between them
