WGU Course C170 - Data Management (Applications) ALL CORRECT AND VERIFIED QUESTIONS AND ANSWERS

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 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-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 answer- 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 answer- 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 answer- 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 answer- 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 answer- D