WGU COURSE C170 - DATA MANAGEMENT (APPLICATIONS)
416QUESTIONS & ANSWERS BEST EXAM SOLUTION GUARANTEED
SUCCESS LATEST 2025/2026 COVERING NURSING FIELD SCORES A+
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 - CORRECT ANSWERS 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 ANSWERS 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 - CORRECT ANSWERS 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. - CORRECT ANSWERS A
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 - CORRECT ANSWERS 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 - CORRECT ANSWERS D
, 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. - CORRECT ANSWERS 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);
416QUESTIONS & ANSWERS BEST EXAM SOLUTION GUARANTEED
SUCCESS LATEST 2025/2026 COVERING NURSING FIELD SCORES A+
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 - CORRECT ANSWERS 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 ANSWERS 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 - CORRECT ANSWERS 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. - CORRECT ANSWERS A
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 - CORRECT ANSWERS 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 - CORRECT ANSWERS D
, 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. - CORRECT ANSWERS 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);
