Can we create non-clustered index on primary key ?
Ans: Yes we can create non-clustered index on primay key in two ways.
First, by default non-clustered index is created while we create a primary key on a column if clustered index exists on same table already.
We can create non-clustered index on a column by explicitly defining while adding a primary key.
Example:
Alter table emp add primary key nonclustered (id)