WGU C175 - Lesson 2: Quiz with Complete Solutions

Document Content and Description Below

WGU C175 - Lesson 2: Quiz with Complete Solutions From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _______ . A business norms B busi ... ness goals C business plans D business rules ✔✔business rules In a SQL-based relational database, each table is dependent on every other table. True or False? ✔✔False A(n) ______'s main function is to help one understand the complexities of the real world environment. A entity B node C database D model ✔✔model The object-oriented data model was developed in the _______ . A 1960s B 1970s C 1980s D 1990s ✔✔1980s A(n) _____ is the conceptual organization of an entire database as viewed by a database administrator. ✔✔schema Which of the following is a disadvantage of the hierarchical data model? A It does not promote data integrity. B It does not have standards. C It does not promote data sharing. D It is not efficient with 1:M relationships. ✔✔It does not have standards. A(n) _____ defines the environment in which data can be managed and is used to work with the data in the database. ✔✔data manipulation language A(n) _______ represents a particular type of object in the real world. A entity B attribute C node D relationship ✔✔entity The network model has structural level dependence. True or False? ✔✔True A verb associating two nouns in a business rule translates to a(n) _______ in the data model. A entity B constraint C relationship D attribute ✔✔relationship Each row in a relation is called a(n) [Show More]

Last updated: 3 years ago

Preview 1 out of 10 pages

Buy Now

Instant download

We Accept: