98-364 Exam - Question 6

Question

Which statement creates a composite key?

Examice · Accepted Answer

A composite key is created by combining two or more columns to form a unique key for a table. In option D, the statement 'PRIMARY KEY(OrderID, OrderItemID)' specifies a primary key that consists of both OrderID and OrderItemID columns. This combination ensures that each row is uniquely identified by the combined values of these two columns, forming a composite key.

jrn1992 · Answer

A composite key is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.

Deehjosh · Answer

the answer is D

elkreationZ · Answer

The correct answer is D

Eva_ · Answer

Isn't primary key unique by itself?

98-364 Exam - Question 6

Discussion