Question: Which option?when placed in the blank space?establishes the PersonlD column as the primary key for the table with a nonclustered index?
- `INDEX ON PersonID (PRIMARY KEY PK_People)`
- `ADD NONCLUSTERED PRIMARY KEY CONSTRAINT PK_People ON PersonID`
- `CONSTRAINT PK_People PRIMARY KEY NONCLUSTERED (PersonID)`
- `PRIMARY KEY CONSTRAINT (PersonID) NONCLUSTERED INDEX`
Answer: The correct answer of the above question is Option D:`PRIMARY KEY CONSTRAINT (PersonID) NONCLUSTERED INDEX`