In which cases should a database be encrypted?

In which cases should a database be encrypted? What is selective database encryption? How would you go about doing it?