I want to buy a second hard drive for my Advent T9206. Could I use a SATA-II or do I need something different?

A standard 3.5" SATA-II HD should work just fine with that Desktop. I'd make sure there is another SATA port available on your Motherboard though.