1|Page
WGU COURSE C170 - DATA
MANAGEMENT (APPLICATIONS) TEST
WITH ACTUAL EXAM TIPS
PASS ON 1ST ATTEMPT
A salesperson is authorized to sell many products and a product can be sold by
many salespersons.
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 -ANS-D
Which kind of relationship is displayed in this entity-relationship diagram?
A Many-to-many unary
B Many-to-many binary
,2|Page
C One-to-one unary
D One-to-one binary -ANS-A
Which kind of relationship is displayed in this entity-relationship diagram?
A Binary many-to-many
B Unary one-to-one
C Ternary many-to-many
D Ternary one-to-one
D Unary many-to-many
E Binary one-to-one -ANS-B
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. -ANS-A
,3|Page
Which two examples are attributes?
Choose 2 answers
1 A meeting code
2 A person attending a meeting
3 An employee number
4 A sales meeting
A 1,3
B 2,4 -ANS-A
Which delete rule sets column values in a child table to a missing value when the
matching data is deleted from the parent table?
A Restrict
B Cascade
C Matching
D Set-to-Null -ANS-D
, 4|Page
In this entity-relationship diagram, Salesperson 361 is related to two customers.
The table 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. -ANS-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);
WGU COURSE C170 - DATA
MANAGEMENT (APPLICATIONS) TEST
WITH ACTUAL EXAM TIPS
PASS ON 1ST ATTEMPT
A salesperson is authorized to sell many products and a product can be sold by
many salespersons.
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 -ANS-D
Which kind of relationship is displayed in this entity-relationship diagram?
A Many-to-many unary
B Many-to-many binary
,2|Page
C One-to-one unary
D One-to-one binary -ANS-A
Which kind of relationship is displayed in this entity-relationship diagram?
A Binary many-to-many
B Unary one-to-one
C Ternary many-to-many
D Ternary one-to-one
D Unary many-to-many
E Binary one-to-one -ANS-B
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. -ANS-A
,3|Page
Which two examples are attributes?
Choose 2 answers
1 A meeting code
2 A person attending a meeting
3 An employee number
4 A sales meeting
A 1,3
B 2,4 -ANS-A
Which delete rule sets column values in a child table to a missing value when the
matching data is deleted from the parent table?
A Restrict
B Cascade
C Matching
D Set-to-Null -ANS-D
, 4|Page
In this entity-relationship diagram, Salesperson 361 is related to two customers.
The table 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. -ANS-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);
