Is there anyone here can explain for me, which is better to use, and why?. In my opinion Sandbox solution is using for site collection and farm solution using for the all web application. Is that true???
The reason for introduction of Sandboxed Solutions was giving ability to work on a partially trusted environment. Without disturbing the Farm Administrators, the Site Collection Admin can handle the deployment. This runs under a set of security policies said CAS Policies. Also with this Sandboxed solutions come under several limitations.
Even a farm solution can be managed to deploy to a particular site collection if needed and the control the sites where the features get activated. Now with SharePoint 2013 and Apps comming in Sandbox solutions are considered obsolete. Still not dead.