What do you call the video effect where water looks like it's standing still when filmed I found a few interesting effects, which was labelled under the rolling shutter effect, however I was told that this was NOT an example of rolling shutter effect, what would you call this effect?

The question is 3 fold: I heard they used this effect in movies, which ones, an example clip would be nice, what do they officially call it, and why does this happen? 

These are the examples I am referring to:
REALLY interesting effects:
For example, the water looks like its static. [PetaPixel][1] explains it; "by pressing a water tube against a speaker, bibio was able to control the vibration frequency of the water flowing through the tube. He then adjusted the pulses of the water to match up with the frame rate of his Canon 5D Mark II."

                
            

Another example was the static helicopter:
This is called stroboscopic effect.  It refers to when the sample rate is synchronized or very slightly out of sync resulting in a much slower representation of the motion that results from taking a picture that is at the same point or slightly advanced point in a subsequent cycle of a higher frequency cyclic motion.

You can actually do the same exact thing in real life for your own eyes by using a strobe light, which is the more common demonstration, though frame rate can be used too if you can adjust it closely enough.