(KHZ, not MHZ)
Pretty much the dual are for deeper water.
Was out in a friends boat who has dual freq (Lowrance X-25), but in a deep lake (up to 400 feet). The 200 MHZ showed far less then the 50 mhz did, but I'm thinking it had more to do with the cone angle (6 degrees for the 200 vs. 19 degrees for the 50) than the power. A single freq has a 20 degree with 200 mhz. As I do not hit the ocean at all, I am looking at a single frequency unit (either the Lowrance LMS-334 or the Eagle FishElite 642C).
Lowrance has a good tutorial on the whole unit.
http://www.lowrance.com/tutorials/sonar/sonar_tutorial_01.asp