My niece, who was 4 at the time, totally freaked. I was surprised since she was too young to be socially conditioned into thinking that sound was scary. Therefore there must be something inherently stamped into our wiring that tells us that stabbing violins are a scary sound.
Or the Grudge sound. (Now, I wanted to put a clip here to remind you what that sounds like, but jeezus, they don't have youtube clips without shots of the girl's face and frankly, I can't take it. And to put it up and have to see it every time I come here would be too much. But here's a stand-in. You get the idea.)
Along the same lines, there's another sound that brings a bit of panic: rattling doorknobs - that sound of someone trying to get into where you are.
Wanna know what makes that sound really well? Little hands spinning those childproofing doorknob thingies. And even though it happens at the bathroom door at 7:15 every morning, I have to admit, it still freaks me out a little bit every time.