The default alarm sound is a Navy Surface ship General Alarm sound, AN/SIA-114B to be precise. Very effective!
We have 5 other alarm sound options you can choose from if you're looking for something less "alarming".