How long can the fish survive in the tank without water pump or air?

Bettas breathe air from the surface of their bowl so it really depends on the humidity of the area that the betta is in when it is out of its bowl. If the betta's body stays well moisturized they can at least live two days out of water (conditions permitting).