Hey THC
Your answer, that the reason why the product is not optically active is because its a racemic mixture, is correct! The two faces of the carbonyl group in butanone is enantiotopic, giving upon addition of a nucleophile like cyanide, two enantiomeric products as a racemic mixture (which is not optically active).
With regards to the mechanism, it is a nucleophilic addition to the carbonyl-group and not an SN2 reaction. Remember that SN2 stands for substitution nucleophilic bimolecular, and therefore you need to do a substitution, in other words you need to have a leaving group, for the reaction to have an SN2-mechanism. In the nucleophilic addition to a carbonyl group you don't have a leaving group, you just add a nucleophile and rearranges some electrons in the molecule. I have sketched the two mechanisms in a jpeg attached.
Hopes this answers your question
Rico