WGU C175/D426 DATA MANAGEMENT FOUNDATIONS
OA EXAM ACTUAL EXAM 2 LATEST VERSIONS 300
QUESTIONS AND CORRECT DETAILED ANSWERS WITH
RATIONALES (100% CORRECT AND VERIFIED
ANSWERS)|ALREADY GRADED A+
Which of the following is true of business rules? - ANSWER: They can serve as a
communication tool between the users and designers.
A(n) _______ is anything about which data are to be collected and stored. -
ANSWER: entity
Oracle 11g is an example of the _______. - ANSWER: XML/Hybrid data model
Each row in the relational table is known as a(n) - ANSWER: entity instance
MySQL is an example of the _______. - ANSWER: relational data model
A(n) _______ is the equivalent of a field in a file system. - ANSWER: attribute
The _______ model was developed to allow designers to use a graphical tool to
examine structures rather than describing them with text. - ANSWER: entity
relationship
The _______ model uses the term connectivity to label the relationship types. -
ANSWER: entity relationship
The object-oriented data model was developed in the _______ . - ANSWER: 1980s
In the _______ model, the user perceives the database as a collection of records in
1:M relationships, where each record can have more than one parent. - ANSWER:
network
_______ are important because they help to ensure data integrity. - ANSWER:
constraints
In ________, a three pronged symbol represents the "many" side of the relationship.
- ANSWER: Crow's Foot notation
A(n) _______ enables a database administrator to describe schema components. -
ANSWER: data definition language (DDL)
VMS/VSAM is an example of the _______. - ANSWER: file system data model
The hierarchical data model was developed in the _______. - ANSWER: 1960s
,One of the limitations of the _______ model is that there is a lack of standards. -
ANSWER: hierarchical
A(n) _______ represents a particular type of object in the real world. - ANSWER:
entity
A(n) ________ defines the environment in which data can be managed and is used
to work with the data in the database. - ANSWER: data manipulation language (DML)
A(n) _______ is a restriction placed on the data. - ANSWER: constraint
Which of the following is true of NoSQL databases? - ANSWER: They are not based
on the relational model.
NoSQL databases: - ANSWER: provide fault tolerance.
A verb associating two nouns in a business rule translates to a(n) _______ in the data
model. - ANSWER: relationship
A(n) _______ is a brief, precise, and unambiguous description of a policy, procedure,
or principle within a specific organization. - ANSWER: business rule
From a database point of view, the collection of data becomes meaningful only when
it reflects properly defined _______ . - ANSWER: business rules
Which of the following is a disadvantage of the hierarchical data model? - ANSWER:
It does not have standards
The relational model's foundation is a mathematical concept known as a - ANSWER:
relation
A(n) _______ is bidirectional. - ANSWER: relationship
The relational data model was developed in the _______. - ANSWER: 1970s
In the _______ model, each parent can have many children, but each child has only
one parent. - ANSWER: hierarchical
Which of the following types of HDFS nodes acts as the interface between the user
application and the HDFS? - ANSWER: client node
Each column in a relation represents a(n) - ANSWER: attribute
In object oriented terms, a(n) ________ defines an object's behavior. - ANSWER:
method
, Each row in a relation is called a(n) - ANSWER: tuple
A(n) ________ is a relatively simple representation of more complex real-world data
structures. - ANSWER: data model
_______ are normally expressed in the form of rules. - ANSWER: constraints
Students and classes have a _______ relationship. - ANSWER: many-to-many
A(n) ______'s main function is to help one understand the complexities of the real
world environment. - ANSWER: model
A(n) _______ is a collection of similar objects with a shared structure and behavior. -
ANSWER: class
A noun in a business rule translates to a(n) _______ in the data model. - ANSWER:
entity
A(n) _______ is the conceptual organization of an entire database as viewed by a
database administrator. - ANSWER: schema
Which of the following types of HDFS nodes stores all the metadata about a file
system? - ANSWER: name node
In the _______ model, the basic logical structure is represented as an upside-down
tree. - ANSWER: hierarchical
The _______ data model is said to be a semantic data model. - ANSWER: object-
oriented
A(n) _______ in a hierarchical model is the equivalent of a record in a file system. -
ANSWER: segment
The _______ data model uses the concept of inheritance. - ANSWER: object-oriented
When you define a table's primary key, the DBMS automatically creates a(n) _____
index on the primary key column(s) you declared. - ANSWER: unique
A(n) _______ provides a detailed description of all tables found within the
user/designer-created database. - ANSWER: data dictionary
The _______ relationship is the relational database norm. - ANSWER: 1:M
A _____ key can be described as a minimal superkey, a superkey without any
unnecessary attributes. - ANSWER: candidate
OA EXAM ACTUAL EXAM 2 LATEST VERSIONS 300
QUESTIONS AND CORRECT DETAILED ANSWERS WITH
RATIONALES (100% CORRECT AND VERIFIED
ANSWERS)|ALREADY GRADED A+
Which of the following is true of business rules? - ANSWER: They can serve as a
communication tool between the users and designers.
A(n) _______ is anything about which data are to be collected and stored. -
ANSWER: entity
Oracle 11g is an example of the _______. - ANSWER: XML/Hybrid data model
Each row in the relational table is known as a(n) - ANSWER: entity instance
MySQL is an example of the _______. - ANSWER: relational data model
A(n) _______ is the equivalent of a field in a file system. - ANSWER: attribute
The _______ model was developed to allow designers to use a graphical tool to
examine structures rather than describing them with text. - ANSWER: entity
relationship
The _______ model uses the term connectivity to label the relationship types. -
ANSWER: entity relationship
The object-oriented data model was developed in the _______ . - ANSWER: 1980s
In the _______ model, the user perceives the database as a collection of records in
1:M relationships, where each record can have more than one parent. - ANSWER:
network
_______ are important because they help to ensure data integrity. - ANSWER:
constraints
In ________, a three pronged symbol represents the "many" side of the relationship.
- ANSWER: Crow's Foot notation
A(n) _______ enables a database administrator to describe schema components. -
ANSWER: data definition language (DDL)
VMS/VSAM is an example of the _______. - ANSWER: file system data model
The hierarchical data model was developed in the _______. - ANSWER: 1960s
,One of the limitations of the _______ model is that there is a lack of standards. -
ANSWER: hierarchical
A(n) _______ represents a particular type of object in the real world. - ANSWER:
entity
A(n) ________ defines the environment in which data can be managed and is used
to work with the data in the database. - ANSWER: data manipulation language (DML)
A(n) _______ is a restriction placed on the data. - ANSWER: constraint
Which of the following is true of NoSQL databases? - ANSWER: They are not based
on the relational model.
NoSQL databases: - ANSWER: provide fault tolerance.
A verb associating two nouns in a business rule translates to a(n) _______ in the data
model. - ANSWER: relationship
A(n) _______ is a brief, precise, and unambiguous description of a policy, procedure,
or principle within a specific organization. - ANSWER: business rule
From a database point of view, the collection of data becomes meaningful only when
it reflects properly defined _______ . - ANSWER: business rules
Which of the following is a disadvantage of the hierarchical data model? - ANSWER:
It does not have standards
The relational model's foundation is a mathematical concept known as a - ANSWER:
relation
A(n) _______ is bidirectional. - ANSWER: relationship
The relational data model was developed in the _______. - ANSWER: 1970s
In the _______ model, each parent can have many children, but each child has only
one parent. - ANSWER: hierarchical
Which of the following types of HDFS nodes acts as the interface between the user
application and the HDFS? - ANSWER: client node
Each column in a relation represents a(n) - ANSWER: attribute
In object oriented terms, a(n) ________ defines an object's behavior. - ANSWER:
method
, Each row in a relation is called a(n) - ANSWER: tuple
A(n) ________ is a relatively simple representation of more complex real-world data
structures. - ANSWER: data model
_______ are normally expressed in the form of rules. - ANSWER: constraints
Students and classes have a _______ relationship. - ANSWER: many-to-many
A(n) ______'s main function is to help one understand the complexities of the real
world environment. - ANSWER: model
A(n) _______ is a collection of similar objects with a shared structure and behavior. -
ANSWER: class
A noun in a business rule translates to a(n) _______ in the data model. - ANSWER:
entity
A(n) _______ is the conceptual organization of an entire database as viewed by a
database administrator. - ANSWER: schema
Which of the following types of HDFS nodes stores all the metadata about a file
system? - ANSWER: name node
In the _______ model, the basic logical structure is represented as an upside-down
tree. - ANSWER: hierarchical
The _______ data model is said to be a semantic data model. - ANSWER: object-
oriented
A(n) _______ in a hierarchical model is the equivalent of a record in a file system. -
ANSWER: segment
The _______ data model uses the concept of inheritance. - ANSWER: object-oriented
When you define a table's primary key, the DBMS automatically creates a(n) _____
index on the primary key column(s) you declared. - ANSWER: unique
A(n) _______ provides a detailed description of all tables found within the
user/designer-created database. - ANSWER: data dictionary
The _______ relationship is the relational database norm. - ANSWER: 1:M
A _____ key can be described as a minimal superkey, a superkey without any
unnecessary attributes. - ANSWER: candidate
