Answer:
Unique Keys Identify Record Uniquely:- Enforcing Unique key on column helps user to avoid duplicate records.PAN Number column can be treated as Uniqe Key because it can not be same for different employees.
Even if we have made a unique key and inserting duplicate data in the unique column(s),Sql Server throws the error.
Asked In: Many Interviews |
Alert Moderator