InterviewSolution
| 1. |
What Is A Concatenated Primary Key? |
|
Answer» Each table has ONE and only one primary key, which can consist of one or many columns. A concatenated primary key comprises two or more columns. In a single table, you MIGHT find several columns, or GROUPS of columns, that might serve as a primary key and are called candidate keys. A table can have more than one candidate key, but only one candidate key can BECOME the primary key for that table. Each table has one and only one primary key, which can consist of one or many columns. A concatenated primary key comprises two or more columns. In a single table, you might find several columns, or groups of columns, that might serve as a primary key and are called candidate keys. A table can have more than one candidate key, but only one candidate key can become the primary key for that table. |
|