What is a composite primary key and when should you use it?

Question Explain

This question assesses understanding of unique identification strategies when single-column keys are insufficient.