*Note: The Holst song does not start playing loud enough to hear until 1:00 into the video.
I'm pretty sure it would be the Beethoven's 5th Symphony, though. The first four (now quite famous) notes strike the dramatic and emotionally jarring "Duh Duh Duh Duh" cadence to which you refer.
NPR posted the text of one All Things Considered show, posted November 19, 20125:11 PM ET, about these notes that you might find interesting: