ABCBiG_Bang is a retail store having millions of purchase records every day. A customer can buy many products and a product can be purchased by many customers. Purchase details are available in a separate relation.

Customer (CustId, Name, Address)
Product (ProdId, Desc, Price, ProdValidity)
Purchase (ProductNo, Quantity, SalesAmount, CustomerNo)

Identify the Primary key for Purchase relation.

ProductNo, Quantity
CustId, Name
ProductNo, SalesAmount
ProductNo, CustomerNo
Verified Answer
Correct Option - d

To get all Infosys Certified Database and SQL Professional Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram