Ok, some quick and dirty answers. You are looking at 2 RCA male plugs. Red goes to the red (audio) female RCA connector on your TV/VCR and the yellow one to the video in RCA plug of TV/VCR. It is a black and white "board camera" of unknown quality in a housing with 6 IR (Infared) LED's (think light you can't see very well, but the camera can see) to boost the IR capability that all board camera have to some degree. Actually, most camcorders have a filter to block the IR. Sony realized that by moving the filter in front of, or away from the camera pickup, and then boosting the output, they can have "night vision". This camera will not let you see someone's "front's closed, deliveries in the back" tatoo under their white jeans like the early and some later Sony camcorder will. Remember you get what you pay for. If you want to be $29.95 happy, this is the one to get. If you want to be twice as happy with the results, search EBay and spend more for a camera where they will tell you what the number of scan lines and the lux level is.
BTW, good find yellowfiero, I think all your stuff is cool.
Edit: Also
here be prepared to scroll down quite a bit, gives some specs.