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 the ruling on istinja' after urination, and is it done with water and soap or with water only?
Istinja' from urine and stool is obligatory. It is permissible to perform istinja' with water alone, or with toilet paper alone. The best way is with toilet paper then water. If one wishes to suffice with one of them, then water is better. And Allah the Almighty knows best.
I prayed while I was in the hospital after a bladder surgery, and my urine was connected to me and could not be disconnected that day. I prayed after performing tayammum with my finger because I was unable to stand. What is the ruling?
After Allah grants you complete healing, make up the prayers you performed with your finger to the best of your ability, at times that suit you. And Allah Knows Best.
What is the ruling on the ablution of one who cuts his nails, and is it permissible to cut them before the ritual bath for major impurity (janabah)?
Cutting nails does not invalidate ablution, and it is permissible to cut them before the ritual bath for major impurity. And Allah the Almighty knows best.