Adobe Exam AD0-E318 Topic 1 Question 14 Discussion

Actual exam question for Adobe's AD0-E318 exam

Question #: 14
Topic #: 1

In the database diagram, a company has tables orders products Recipient items.

* Recipient is linked to Orders as 1-N

* Products to Orders as N-N

Recipient ID, Email Full Name, Customer ID Orders: Orders ID, Recipient ID, Product ID, Date of purchase items: Product ID, order ID, item ID products Product ID, Name, Status, Creation Date.

Which columns act as both primary and forgive keys?

ARecipient ID, Product ID, Order ID

BCustomer ID, Product ID, item ID

COrder ID, Recipient ID, item ID

DRecipient ID, Product ID, Customer ID

Show Suggested Answer

Suggested Answer: A

The Product ID column acts as the primary key for the Products table and as a foreign key for the Orders table. The Order ID column acts as the primary key for the Orders table and as a foreign key for the Items table. The Customer ID, Product ID, and Item ID columns do not act as primary or foreign keys.

by Jesusita at Mar 31, 2023, 07:20 AM

Limited Time Offer

25%

Off

Get Premium AD0-E318 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!