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 business 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) _____ . ✔✔tuple
A(n) _______ is bidirectional.This task contains the radio buttons and checkboxes for options.
A entity
B attribute
C constraint
D relationship ✔✔relationship
Complete Solutions
From a database point of view, the collection of data becomes meaningful only when it reflects
properly defined _______ .
A business norms
B business 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) _____ . ✔✔tuple
A(n) _______ is bidirectional.This task contains the radio buttons and checkboxes for options.
A entity
B attribute
C constraint
D relationship ✔✔relationship
