Chinese is not related to any of the above languages; it is part of the Sino-Tibetan language group.
Japanese is not related to Chinese; it may be related to Korean; possibly it may be distantly related to the Altaic languages.
Where you get the idea that any of the above are related to the Picts is beyond me. But just mention the word "Pict", and every kind of weird and harebrained theory is trotted forth. In fact, enough of Pictish has now been deciphered from inscriptions, to place Pictish in the Brythonic Celtic group.
But these pet theories never seem to die; everyone wants a piece of the action, no matter how improbable.
It is almost certainly related to Korean (the most plausible explanation I've heard is that the Japanese came from one of the Three Kindoms while Korean comes from a different dialect but this is a very politically touchy topic -- more touchy than the question of who came to America first).
The Altaic languages are also probably related to the Uralic languages. From what I've seen looking at language families is that there is a Northern migration band that runs from Finland to Japan that involves Ural-Altaic languages and a Southern migration band that runs from Ireland to India and Western China that involves the Indo-European languages.