Zweihander
http://1.bp.blogspot.com/_9HgCrmhTyAE/SxHphqKP6RI/AAAAAAAAAag/7Hax-n3xa7k/s320/zweihander.jpg
Zwei means "two" in German, so yes, it is a two-hand sword
As for the sword in the OP's link, it is merely a 2-hand sword, with added touches by the artist to make it look more "Nordish", such as the shape and engraving of the hand guard.The guard on the OP's link, while sloped, is rather short, compared to the guards 2-handed swords sported in the past. The guard looks more as if it came from a Nordic sword.
2-hand swords are popularly referred to as "claymores", which comes from the Gaelic for "great sword". This great sword was popular among the Scottish clans during the middle ages. Of course, everyone who watched Braveheart knows this.
Oh, and no, I didn't "google" it, I have owned one for many years, and I bought it before Braveheart came out
Part of a small, but very impressive collection... if I say so myself