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].
A man who was on travel prayed Duhr as four Rakhas upon leaving Tafilah heading to Amman. However, on his way to Amman, he prayed Asir as two Rakhas (Shortened). Is what he did correct from an Islamic perspective?
All perfect praise be to Allah, The Lord of The Worlds. May His blessings and peace be upon our Prophet Mohammad and upon all his family and companions.
What he did is correct; he is liable for nothing before Allah The Almighty, since combining and shortening prayers during travel are two separate concessions. Therefore, it is permissible for a traveler to shorten prayer without combining it with another. And Allah The Almighty Knows Best.
Is it permissible to offer mandatory prayer while sitting?
All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions. Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah Knows Best.
I can`t afford to get married, what should I do to curb my sexual drives?
You should offer a lot of voluntary fasting, keep busy with useful and permissible acts and make supplication to Allah, The Exalted.