Yes, it can be turned off. From the Idle screen, press (Menu) ➔ Settings ➔
Personalize ➔ Sound profiles. There you can customize a Sound profile to turn off message alerts.
Source: Page 76 of the user manual that you can download for free on Samsung S275 page.