John Ratcliffe has been confirmed to lead the Central Intelligence Agency (CIA) after the Senate confirmed his appointment.