Multiple choice technology databases

Can a primary key contain more than one columns?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A primary key can definitely contain more than one column - this is called a composite primary key. For example, a table storing order line items might use (order_id, line_item_id) together as the primary key. Composite primary keys are common when no single column uniquely identifies each row.