• I think it's a fair/decent question.  A good job candidate should be prepared to ask the only relevant question when presented with this question:  "What is the scope?"  That's the only piece of information you need in order to determine which method of returning the last inserted identity value is appropriate.

    Another good interview question involves how to retrieve a GUID after an INSERT.