A series of three notes, the first two are short, the third is elongated. You would hear it in, say, a cheesy soap opera or horror movie (or, more likely, a spoof of same), to indicate a shocking or horrifying revelation.
“The phone call is coming from within the house!” [cue effect]
I don’t know if it has an official name, but it is commonly called the “dun dun dun” sound effect, sometimes with an alternate spelling such as “dun dun duuuuunnnnn” or with similar emphasis on the last note.
Googling “dun dun dun” will give you lots of hits. If there’s an official name for it (other than dun dun dun) you can probably find it that way.