InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Consider the following table:EmployeeEmpNoEmpNameDesignation1SahilA2AnupB3MansiA4PoojaB1. Which of the above field can be selected as a primary key?2. EmpName field also has unique values for all the records. Can it be made primary key? Give answer with reason. |
|
Answer» 1. EmpNo can be selected as a primary key. 2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names. So, in future, its values may be duplicate. Thus, it cannot be made as a primary key. |
|