General validity of the second fluctuation-dissipation theorem in the nonequilibrium steady state: Theory and applications