Earlier quoted context omitted.
An urban legend. Microwaves cause heating across a wide range of frequencies.
Not really: Consumer ovens work around a nominal 2.45 gigahertz (GHz)—a wavelength of 12.2 centimetres (4.80 in) in the 2.4 GHz to 2.5 GHz ISM band
And as they correctly point out, that consumer ovens use a specific frequency has nothing to do with it being a resonance frequency of water, but it being a reasonable to use and legal frequency to do so. They would work on 1 GHz or 5 GHz too.