Multiple choice technology databases

which is correct about COMPOSITE KEY?

  1. both column data type must be same

  2. both colmun data type need not be same

  3. one of the data type must be different

  4. both column data type and length must be same

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

A composite key combines multiple columns as a primary key. The columns can have different data types - there's no requirement for type matching. Only the combination of values must be unique.