Tight Bounds on the Approximability of Almost-satisfiable Horn SAT and Exact Hitting Set}