WGU C175 - data management Exam test
preparation Questions and Must have
marking scheme Updated version 2024/2025
Which kind of data in this database would qualify as *intersection data* related to both
the product and salesperson entities? - correct answer customer names
What is an attribute or group of attributes that *uniquely identify* a tuple in a relation? -
correct answer primary key
What is necessary for a primary key in one relation of a database to match with its
corresponding foreign key in another relation of the same database? - correct answer
a domain of values
What uniquely identifies each entity in a collection of entities but is not the primary key?
- correct answer the alternate key
What is a term for a set of columns in a table that can uniquely identify any record in
that table without referring to other data? - correct answer candidate key
What happens to the *original data* in database indexing? - correct answer it is copied
to the index.
Why are indexes created in a physical database design? - correct answer to retrieve
data directly using a pointer
Why is an index created on a database column? - correct answer to optimize data
retrievals
What is a *methodology* for organizing attributes into tables? - correct answer data
normalization
, What is the term for the value of one particular attribute *associated with a specific
single value of another* attribute? - correct answer functional dependency
In which state are the attributes shown? - correct answer 1nf (first normal form)
Refer to the given table.
Stu id---st ln----idprof--prof---------grade
1---------mueller---3------schmid--------5
2---------meier-----2------borner--------4
3---------tobler----1-------bernasconi---6
Which factor determines whether the table is in first normal form? - correct answer the
attributes are all single valued.
Refer to the given tables.
Id--------contract-----code
1----------vinod--------091
2----------rajiv---------091
Code---city-----------country
091------bangalore----india
The primary key in the first table is *id*, and the primary key in the second is *code*.
How advanced are the two tables in the normalization process? - correct answer third
normal form
preparation Questions and Must have
marking scheme Updated version 2024/2025
Which kind of data in this database would qualify as *intersection data* related to both
the product and salesperson entities? - correct answer customer names
What is an attribute or group of attributes that *uniquely identify* a tuple in a relation? -
correct answer primary key
What is necessary for a primary key in one relation of a database to match with its
corresponding foreign key in another relation of the same database? - correct answer
a domain of values
What uniquely identifies each entity in a collection of entities but is not the primary key?
- correct answer the alternate key
What is a term for a set of columns in a table that can uniquely identify any record in
that table without referring to other data? - correct answer candidate key
What happens to the *original data* in database indexing? - correct answer it is copied
to the index.
Why are indexes created in a physical database design? - correct answer to retrieve
data directly using a pointer
Why is an index created on a database column? - correct answer to optimize data
retrievals
What is a *methodology* for organizing attributes into tables? - correct answer data
normalization
, What is the term for the value of one particular attribute *associated with a specific
single value of another* attribute? - correct answer functional dependency
In which state are the attributes shown? - correct answer 1nf (first normal form)
Refer to the given table.
Stu id---st ln----idprof--prof---------grade
1---------mueller---3------schmid--------5
2---------meier-----2------borner--------4
3---------tobler----1-------bernasconi---6
Which factor determines whether the table is in first normal form? - correct answer the
attributes are all single valued.
Refer to the given tables.
Id--------contract-----code
1----------vinod--------091
2----------rajiv---------091
Code---city-----------country
091------bangalore----india
The primary key in the first table is *id*, and the primary key in the second is *code*.
How advanced are the two tables in the normalization process? - correct answer third
normal form
