multiple SQL databases in a farm

Is it recommended to have multiple SQL servers in a farm to host content databases or usually just one? sorry if this is a basic question but i am new to the SP architecture

thanks,

Jay