Which statement creates a composite key?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
D.
2
0
A composite primary key occurs when you define more than one column as your PRIMARY KEY
0
1
did anyone give MTA 98-364 exam recently? is this sample test worth trying?
0
0
Answer A is wrong, gives error:
Msg 8110, Level 16, State 0, Line 1
Cannot add multiple PRIMARY KEY constraints to table ‘ORDER’.
Answer B seems wrong, gives error:
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ‘,’.
Answer C seems wrong, gives error:
Msg 8135, Level 16, State 0, Line 1
Table level constraint does not specify column list, table ‘ORDER’.
Answer D, seems right, query succesfull and 2 PK’s.
3
0