How does a composite key differ from a single-column key in a database?
- Composite key and Single-column key are identical
- Composite key is made up of multiple columns, Single-column key uses only one column
- Composite key is used for foreign key relationships, Single-column key is not
- Single-column key is made up of multiple columns, Composite key uses only one column
A composite key consists of multiple columns to uniquely identify a record, whereas a single-column key uses only one column for this purpose. Composite keys are often used when a single column cannot guarantee uniqueness.
Loading...
Related Quiz
- What is the primary purpose of indexing in a database?
- In NoSQL databases, a _______ is a unique identifier associated with each document in a collection.
- What is the primary goal of denormalization in database design?
- What is meant by the term "attribute" in an ERD context?
- How does partitioning contribute to storage optimization in distributed databases?