Yes, in rare cases. Normally, lack of oxygen will cause brain death within about 5 minutes or so, but in cases of "cold water drowning" in which the victim was immersed in extremely cold water, brain damage is slowed considerably.
It is an axiom among rescue crews that "You're not really dead until you're WARM and dead". I believe that the maximum time between "drowning" and a successful revival is around 40 minutes.
If the rescuers perform CPR while warming the victim, there is a chance - perhaps not a good chance, but a chance! - that the victim can recover with little or no brain damage. This has been observed when small children drown in very cold water; their body mass is so low that they retain very little heat, and they cool quickly into almost a state of "suspended animation". There have been several near-miraculous recoveries in which the victim suffered no long-term ill effects.
Without breathing? The record is about 3.5 minutes.
While inside a pressurized habitat? There isn't any limit; in the future, we will build cities beneath the sea and colonize the continental shelf and ocean deeps. Some people may never come to the surface. People will be born there, grow up and grow old there, and die in aquatic cities.
All of its life.
The average human can survive under water for approximately 5 minutes but no more then 10.
With sufficient nutritious food and plenty of water, a person can survive indefinitely.
They are water based animals so can survive under water for approximately 60 minutes, but without water 3.7 seconds
Indefinitely, especially if they die in the process. Your time under water and your ability to survive it depend on a number of factors. In water near freezing, the average person will die from hypothermia in minutes. If the person has a lot of insulation (wet suit or fat) they can survive longer. If the water is near body temperature, the limiting factor is probably going to be food. If it is salt water, the limiting factor will be water to drink. If you supply food, the person will be able to survive longer but will probably succumb to an infection because the average human's skin will degrade from continuous immersion.
magic
No, they don't. They cannot survive long underwater. If they are put under water for too long they will die.
Cockroaches can survive under water for up to 15 minutes. http://ct.water.usgs.gov/education/riverfacts.htm Mythbusters showed 5 of 5 cockroaches survived after being under water for 30 minutes http://dsc.discovery.com/videos/mythbusters-drowning-cockroaches.html
A person can only survive about a week because every human need water to survive
3 days, under normal conditions. It should be noted, however, that the environment can also affect how long we can survive without water. This includes air temperature, relative humidity etc.
2 mins under stress in a cage and panic. Srs.
With sufficient water and food a person could survive indefinitely. Without water, just 2-3 days in the summer months.