Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?
If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].
What is permissible for the husband to do as far as having sex with his wife is concerned?
The couple are free to enjoy each other sexually provided that they don`t do it during menses. It is also forbidden for the husband to enjoy the wife from her anus.
When the soul leaves the body, does it hear and see? And where does the soul go?
The important thing is that the soul departs while its owner is a believing, repentant Muslim, as this is a good ending. As for the details, they are lengthy. The grave is either a garden from the gardens of Paradise or a pit from the pits of Hellfire. And Allah The Almighty Knows Best.
What is the ruling on reciting verses of the Holy Quran on water, then drinking it?
It is permissible to recite Quran on water, then drink it as a kind of treatment since the Quran heals. Allah, The Almighty, Says (What means): "We send down (stage by stage) in the Qur’an that which is a healing and a mercy to those who believe: to the unjust it causes nothing but loss after loss." [Al-Isra`/82].