The difference between the two fields is the same anywhere that you can choose one value or multiple values. Any ACF field that allows multiple values to be selected stores that values as a serialized array instead of a single value. The best explanation of querying values that store serialized arrays in on this page http://www.advancedcustomfields.com/resources/querying-relationship-fields/
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users