C175 - Data Management Foundations PA Revised Test.
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 item represents unstructured data? - correct answer Training Video Content 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 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 What is the entity-relationship diagram about a car rental agency showing? - correct answer One manufacturer created at least one of the agency's cars. 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 relationship does the cardinality in the diagram represent? - correct answer Many customers to many products How is the cardinality of the customers misrepresented? - correct answer There are many customers, but the cardinality indicates one customer. What is the correct way to read the modality on the right side of the association? - correct answer A minimum of zero customers What is the modality of the product? - correct answer At least one Which kind of relationship does this diagram depict? - correct answer Unary one-to-one Which kind of relationship does this diagram depict? - correct answer Unary one-to-many Which three kinds of rules for *referential integrity* are provided by modern relational database management systems? - correct answer Insert
Document information
- Uploaded on
- March 14, 2024
- Number of pages
- 9
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers