generally wet battery refers to old style lead acid batteries, like what is in your car. very stable technology, but they have many cons, like requiring maintenance and stuff
dry batteries probably means newer technology like nickel metal hydrive or lithium ion. they probably have a lower capacity and higher cost, but don't require maintenance and are smaller/lighter, etc
how big of UPS are you talking about? giant ones for data centers? or small desktop type units?