Can't remember, but I think you're talking about "Final Fantasy"; yes, the song's called like this and it's played in almost every FF (I-IX except for VII).