Do you really have to give up your original nationality if you become Spanish?

Which countries does Spain have dual nationality agreements with for citizenship applications through residency? Do you really have to give up your original nationality if there isn't a deal, and what can happen if you use your non-Spanish passport?