Aquarium fish can survive for up to 48 hours without oxygen in stagnant water, but they require additional oxygen to carry out their necessary activities.