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 of Sharia on woman shaking hands with non-Mahram man?
All perfect praise be to Allah the Lord of the Worlds. May His peace and blessings be upon our Prophet Mohammad and upon all his family and companions.
The Messenger of Allah (PBUH) said: "It is better to be stabbed in the head than touch a woman to whom one isn`t related." [Transmitted by Al-Tabarani /Al-Mo`jam Al-Kabir, Hadith No.16880]. Accordingly, it is forbidden for men to shake hands with non-Mahram* woman. And Allah The Almighty Knows Best.
* The women/men that you are allowed to marry. It includes all women/men other than mahram (including cousins).
Is it permissible to repeat the Istikhara (seeking guidance) prayer, and is it a condition that one should sleep after offering it?
All perfect praise be to Allah,The Lord of The Worlds Istikhara is offered once, but it is permissible to repeat it, and sleeping after offering it is not a condition for its validity. And Allah Knows Best.
Should a person who doesn’t offer Tasbeehb (saying Subhaana Rabbiya Al-‘Atheem during Rukoo`, and saying Subhaana Rabbiya Al-A‘laa during Sujood) during Rukoo` and Sujood perform As-Sahw Sujood (prostration of forgetfulness)?
He/ she doesn`t have to perform Sujood As-Sahw, whether he/she didn`t offer Tasbeeh during Rukoo` and Sujood either intentionally ,or unintentionally, provided that the attentiveness of the heart wasn`t undermined since it is a pillar in both.