WGU C170 DATA MANAGEMENT
APPLICATIONS PRACTICE EXAM
QUESTIONS700 QUESTIONS &
ANSWERS 2026 VERIFIED
A salesperson is authorized to sell many products and a product can be sold by manysalespersons.
Which kind of binary relationship does this scenario describe?
A One-to-one B
One-to-many
C One-to-one binary
D Many-to-many Correct answer- D
Which kind of relationship is displayed in this entity-relationship diagram?
A Many-to-many unary B
Many-to-many binary C
One-to-one unary
D One-to-one binary Correct answer- A
Which kind of relationship is displayed in this entity-relationship diagram?
A Binary many-to-manyB
Unary one-to-one
C Ternary many-to-manyD
Ternary one-to-one
D Unary many-to-many
E Binary one-to-one Correct answer- B
1
,How is this portion of the entity-relationship diagram read, from left to right?
A At least one book was written by an author.B
Only one book was written by one author. C No
books are written by an author.
D One book was written by more than one author. Correct answer- A
A(n) exists when there are functional dependencies such that Y is functionally
dependent on X, Z is functionally dependent on Y, and X is the primary key.
A
transitive dependencyB
partial dependencyC
repeating groupD
atomic attribute Correct answer- A
It is possible for a table in 2NF to exhibit transitive dependency, where the primary keymay rely
on one or more nonprime attributes to functionally determine other nonprime attributes.
A
False
B
True Correct answer- B
Dependency diagrams are very helpful in getting a bird's eye view of all the
relationships among a table's attributes.
A
True
2
,B
False Correct answer- A
The objective of normalization is to ensure that each table conforms to the concept ofwell-
formed relations.
A
True
B
False Correct answer- A
If a table has multiple candidate keys and one of those candidate keys is a composite key, the
table can have based on this composite candidate key even when the primary key chosen is a
single attribute.
A
Boyce-Codd normal formsB
partial dependenciesC
time-variances
D
redundancies Correct answer- B
A set of instructions generated at application compilation time that is created and managed by a
DBMS. It also predetermines how an application's query will access thedatabase at run time.
Correct answer- access plan
An ordered data structure organized as an upside-down tree. Correct answer- B-treeindex
An index that uses a bit array (0s and 1s) to represent the existence of a value or
condition. Correct answer- bitmap index
Which two examples are attributes?
Choose 2 answers
A meeting code
1 A person attending a meeting3
An employee number
4 A sales meeting
A 1,3
B 2,4 Correct answer- A
Which delete rule sets column values in a child table to a missing value when thematching data is
deleted from the parent table?
3
, A Restrict B
CascadeC
Matching
D Set-to-Null Correct answer- D
In this entity-relationship diagram, Salesperson 361 is related to two customers. Thetable
follows the restrict delete rule.
What happens if someone tries to delete Salesperson 361 from the customer records?
A The delete occurs immediately.
B The lack of a salesperson is flagged for later.C A
new salesperson is assigned instead.
D The delete is prohibited. Correct answer- D
Refer to the given SQL statement.
CREATE TABLE member(member_idINT UNSIGNED NOT NULL
AUTO_INCREMENT,PRIMARY KEY (member_id),last_nameVARCHAR(20) NOT
NULL,first_nameVARCHAR(20) NOT NULL,suffixVARCHAR(5) NULL,expirationDATE
NULL,emailVARCHAR(100) NULL,streetVARCHAR(50) NULL,cityVARCHAR(50)
NULL,stateVARCHAR(2) NULL,zipVARCHAR(10) NULL,phoneVARCHAR(20)
NULL,interestsVARCHAR(255) NULL);
4
APPLICATIONS PRACTICE EXAM
QUESTIONS700 QUESTIONS &
ANSWERS 2026 VERIFIED
A salesperson is authorized to sell many products and a product can be sold by manysalespersons.
Which kind of binary relationship does this scenario describe?
A One-to-one B
One-to-many
C One-to-one binary
D Many-to-many Correct answer- D
Which kind of relationship is displayed in this entity-relationship diagram?
A Many-to-many unary B
Many-to-many binary C
One-to-one unary
D One-to-one binary Correct answer- A
Which kind of relationship is displayed in this entity-relationship diagram?
A Binary many-to-manyB
Unary one-to-one
C Ternary many-to-manyD
Ternary one-to-one
D Unary many-to-many
E Binary one-to-one Correct answer- B
1
,How is this portion of the entity-relationship diagram read, from left to right?
A At least one book was written by an author.B
Only one book was written by one author. C No
books are written by an author.
D One book was written by more than one author. Correct answer- A
A(n) exists when there are functional dependencies such that Y is functionally
dependent on X, Z is functionally dependent on Y, and X is the primary key.
A
transitive dependencyB
partial dependencyC
repeating groupD
atomic attribute Correct answer- A
It is possible for a table in 2NF to exhibit transitive dependency, where the primary keymay rely
on one or more nonprime attributes to functionally determine other nonprime attributes.
A
False
B
True Correct answer- B
Dependency diagrams are very helpful in getting a bird's eye view of all the
relationships among a table's attributes.
A
True
2
,B
False Correct answer- A
The objective of normalization is to ensure that each table conforms to the concept ofwell-
formed relations.
A
True
B
False Correct answer- A
If a table has multiple candidate keys and one of those candidate keys is a composite key, the
table can have based on this composite candidate key even when the primary key chosen is a
single attribute.
A
Boyce-Codd normal formsB
partial dependenciesC
time-variances
D
redundancies Correct answer- B
A set of instructions generated at application compilation time that is created and managed by a
DBMS. It also predetermines how an application's query will access thedatabase at run time.
Correct answer- access plan
An ordered data structure organized as an upside-down tree. Correct answer- B-treeindex
An index that uses a bit array (0s and 1s) to represent the existence of a value or
condition. Correct answer- bitmap index
Which two examples are attributes?
Choose 2 answers
A meeting code
1 A person attending a meeting3
An employee number
4 A sales meeting
A 1,3
B 2,4 Correct answer- A
Which delete rule sets column values in a child table to a missing value when thematching data is
deleted from the parent table?
3
, A Restrict B
CascadeC
Matching
D Set-to-Null Correct answer- D
In this entity-relationship diagram, Salesperson 361 is related to two customers. Thetable
follows the restrict delete rule.
What happens if someone tries to delete Salesperson 361 from the customer records?
A The delete occurs immediately.
B The lack of a salesperson is flagged for later.C A
new salesperson is assigned instead.
D The delete is prohibited. Correct answer- D
Refer to the given SQL statement.
CREATE TABLE member(member_idINT UNSIGNED NOT NULL
AUTO_INCREMENT,PRIMARY KEY (member_id),last_nameVARCHAR(20) NOT
NULL,first_nameVARCHAR(20) NOT NULL,suffixVARCHAR(5) NULL,expirationDATE
NULL,emailVARCHAR(100) NULL,streetVARCHAR(50) NULL,cityVARCHAR(50)
NULL,stateVARCHAR(2) NULL,zipVARCHAR(10) NULL,phoneVARCHAR(20)
NULL,interestsVARCHAR(255) NULL);
4
