Multiple choice technology databases

What is the limit of the no of columns on a primary key in relational model?

  1. 16

  2. 32

  3. 64

  4. There is no limit on the no. of columns.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The relational model itself imposes no theoretical limit on the number of columns in a primary key. However, database systems (like Oracle's limit of 32 columns or DB2's limit of 64) impose physical implementation limits.

Keep practicing — related questions