I was told by the holder of a Secret clearance here in Aus that the interviews about background were largely about exposing potential blackmail levers and less about moral transgressions.

He also mentioned three general levels of clearance - classified, secret negative, secret positive. Negative is closer to a background check in style. Positive is the exhaustive fine-toothed comb.