70-463 · Question #138
70-463 Question #138: Real Exam Question with Answer & Explanation
The correct answer is C: EmployeeID. An IDENTITY specification auto-generates sequential numeric values and is used on surrogate primary key columns. EmployeeID is the primary key of the Employee table - the system-generated identifier that uniquely identifies each row. A seed of 1,000 means the first inserted row r
Question
Exhibits
Options
- ADateHired
- BDepartmentID
- CEmployeeID
- DEmployeeNum
- EFirstName
- FJobTitle
- GLastName
- HMiddleName
- IReportsToID
Explanation
An IDENTITY specification auto-generates sequential numeric values and is used on surrogate primary key columns. EmployeeID is the primary key of the Employee table - the system-generated identifier that uniquely identifies each row. A seed of 1,000 means the first inserted row receives the value 1,000, and an increment of 1 means each subsequent row increases by 1. The other columns are disqualified for identity: DateHired is a date type, FirstName/LastName/MiddleName/JobTitle are strings, DepartmentID and ReportsToID are foreign keys pointing to other tables, and EmployeeNum is typically a business-assigned identifier - none of these should be auto-incremented system keys.
Community Discussion
No community discussion yet for this question.