When you're unchecking "Automatic profile activation after joining" the member is still able to login, although his status is Approval and he can't do almost anything.
But with "Mandatory Confirmation" such a member wouldn't be able to login, untill approved or confirmed his email. In other words member will not be able to login at all till his profile staus isn't Active.