WGU C175 Knowledge test Exam Toolkit
Questions and Verified Marking Scheme
2024/2025
Database programming languages receive all application requests and translate them
into the complex operations required to fulfill those requests. - correct answer False
________ exists when it is possible to make changes in the data storage characteristics
without affecting an application program's ability to access data. - correct answer Data
independence
________ exists when different and conflicting versions of the same data appear in
different places. - correct answer Data inconsistency
One of the limitations of the _______ model is that there is a lack of standards. -
correct answer hierarchical
A(n) _______ represents a particular type of object in the real world. - correct answer
entity
Even when a good database blueprint is available, an applications programmer's view
of the data should match that of the manager and the end user. - correct answer False
A data model is usually graphical. - correct answer True
In object oriented terms, a(n) ________ defines an object's behavior. - correct answer
method
M:N relationships are not appropriate in a relational model. - correct answer True
,The _______ model was developed to allow designers to use a graphical tool to
examine structures rather than describing them with text. - correct answer entity
relationship
_______ are normally expressed in the form of rules. - correct answer Constraints
What type of HDFS nodes stores all the metadata about a file system? - correct
answer Name node
Mysql is an example of the _______. - correct answer relational data model
The _______ data model is said to be a semantic data model. - correct answer object-
oriented
A(n) ________ is a relatively simple representation of more complex real-world data
structures. - correct answer data model
The _______ model uses the term connectivity to label the relationship types. - correct
answer entity relationship
The hierarchical model is software-independent. - correct answer False
In an SQL-based relational database, each table is dependent on every other table. -
correct answer False
VMS/VSAM is an example of the _______. - correct answer file system data model
A disadvantage of the relational database management system (RDBMS) is its inability
to hide the complexities of the relational model from the user. - correct answer False
,You can think of a table as a persistent representation of a logical relation. - correct
answer True
Character data can contain any character or symbol intended for mathematical
manipulation. - correct answer False
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. - correct answer
network
Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain. - correct answer True
In an SQL-based relational database, rows in different tables are related based on
common values in common attributes. - correct answer True
A(n) ________ defines the environment in which data can be managed and is used to
work with the data in the database. - correct answer data manipulation language
(DML)
Nosql are not based on the relational model. - correct answer True
A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure,
or principle within a specific organization. - correct answer business rule
Each table in a relational database must have a primary key. - correct answer True
An implementation-ready data model needn't necessarily contain enforceable rules to
guarantee the integrity of the data. - correct answer False
Nosql databases provide ___ - correct answer fault tolerance.
, A(n) _______ is a restriction placed on the data. - correct answer constraint
Each row in a relation is called a(n) ________ . - correct answer tuple
From a database point of view, the collection of data becomes meaningful only when it
reflects properly defined _______ . - correct answer business rules
Database designers determine the data and information that yield the required
understanding of the entire business. - correct answer False
The relational model is hardware-dependent and software-independent. - correct
answer False
The network model has structural level dependence. - correct answer True
The object-oriented data model was developed in the _______ . - correct answer
1980s
In the context of data models, an entity is a person, place, thing, or event about which
data will be collected and stored. - correct answer True
What type of HDFS nodes acts as the interface between the user application and the
HDFS? - correct answer Client node
Only a single attribute, not multiple attributes, can define functional dependence. -
correct answer False
In ________ , a three pronged symbol represents the "many" side of the relationship. -
correct answer Crow's Foot notation
Questions and Verified Marking Scheme
2024/2025
Database programming languages receive all application requests and translate them
into the complex operations required to fulfill those requests. - correct answer False
________ exists when it is possible to make changes in the data storage characteristics
without affecting an application program's ability to access data. - correct answer Data
independence
________ exists when different and conflicting versions of the same data appear in
different places. - correct answer Data inconsistency
One of the limitations of the _______ model is that there is a lack of standards. -
correct answer hierarchical
A(n) _______ represents a particular type of object in the real world. - correct answer
entity
Even when a good database blueprint is available, an applications programmer's view
of the data should match that of the manager and the end user. - correct answer False
A data model is usually graphical. - correct answer True
In object oriented terms, a(n) ________ defines an object's behavior. - correct answer
method
M:N relationships are not appropriate in a relational model. - correct answer True
,The _______ model was developed to allow designers to use a graphical tool to
examine structures rather than describing them with text. - correct answer entity
relationship
_______ are normally expressed in the form of rules. - correct answer Constraints
What type of HDFS nodes stores all the metadata about a file system? - correct
answer Name node
Mysql is an example of the _______. - correct answer relational data model
The _______ data model is said to be a semantic data model. - correct answer object-
oriented
A(n) ________ is a relatively simple representation of more complex real-world data
structures. - correct answer data model
The _______ model uses the term connectivity to label the relationship types. - correct
answer entity relationship
The hierarchical model is software-independent. - correct answer False
In an SQL-based relational database, each table is dependent on every other table. -
correct answer False
VMS/VSAM is an example of the _______. - correct answer file system data model
A disadvantage of the relational database management system (RDBMS) is its inability
to hide the complexities of the relational model from the user. - correct answer False
,You can think of a table as a persistent representation of a logical relation. - correct
answer True
Character data can contain any character or symbol intended for mathematical
manipulation. - correct answer False
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. - correct answer
network
Within the database environment, a data model represents data structures with the
purpose of supporting a specific problem domain. - correct answer True
In an SQL-based relational database, rows in different tables are related based on
common values in common attributes. - correct answer True
A(n) ________ defines the environment in which data can be managed and is used to
work with the data in the database. - correct answer data manipulation language
(DML)
Nosql are not based on the relational model. - correct answer True
A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure,
or principle within a specific organization. - correct answer business rule
Each table in a relational database must have a primary key. - correct answer True
An implementation-ready data model needn't necessarily contain enforceable rules to
guarantee the integrity of the data. - correct answer False
Nosql databases provide ___ - correct answer fault tolerance.
, A(n) _______ is a restriction placed on the data. - correct answer constraint
Each row in a relation is called a(n) ________ . - correct answer tuple
From a database point of view, the collection of data becomes meaningful only when it
reflects properly defined _______ . - correct answer business rules
Database designers determine the data and information that yield the required
understanding of the entire business. - correct answer False
The relational model is hardware-dependent and software-independent. - correct
answer False
The network model has structural level dependence. - correct answer True
The object-oriented data model was developed in the _______ . - correct answer
1980s
In the context of data models, an entity is a person, place, thing, or event about which
data will be collected and stored. - correct answer True
What type of HDFS nodes acts as the interface between the user application and the
HDFS? - correct answer Client node
Only a single attribute, not multiple attributes, can define functional dependence. -
correct answer False
In ________ , a three pronged symbol represents the "many" side of the relationship. -
correct answer Crow's Foot notation
