[amp_mcq option1=”Required when a table does not have any unique fields in it” option2=”The primary key with AutoNumber as the field type” option3=”Made up of two or more fields to uniquely identify records” option4=”Is a foreign key that uniquely identifies records” correct=”option3″]<\/p>\n
The correct answer is: C. Made up of two or more fields to uniquely identify records.<\/p>\n
A composite key is a primary key that is made up of two or more fields. It is used to uniquely identify records in a table. For example, a table of employees might have a composite key made up of the employee’s first name and last name. This would ensure that each employee is only represented once in the table.<\/p>\n
Option A is incorrect because a composite key is not required when a table does not have any unique fields in it. In this case, a single-field primary key can be used.<\/p>\n
Option B is incorrect because the primary key with AutoNumber as the field type is not necessarily a composite key. It can be a single-field primary key.<\/p>\n
Option D is incorrect because a foreign key is a field or group of fields that refers to the primary key of another table. It is not used to uniquely identify records.<\/p>\n","protected":false},"excerpt":{"rendered":"
[amp_mcq option1=”Required when a table does not have any unique fields in it” option2=”The primary key with AutoNumber as the field type” option3=”Made up of two or more fields to uniquely identify records” option4=”Is a foreign key that uniquely identifies records” correct=”option3″]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[672],"tags":[],"class_list":["post-15754","post","type-post","status-publish","format-standard","hentry","category-ms-access","no-featured-image-padding"],"yoast_head":"\n