Is the two Raka's after Friday Prayer an act of Sunna?
Performing Two prostrations after the call of Friday's Athan is an act of Sunna, since Al-Bukhari stated in his Sahih: (The chapter of praying before and after Friday's prayer). This indicates that he mentions Friday's prayer exactly as the Duhr prayer (Afternoon prayer) as regards praying before and after the call of Athan. And Allah Knows Best.
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].
Is it permissible for a financially capable woman to pay the Zakat to her sons or one of them?
It is permissible for a mother to give her children from zakat if they are eligible to receive it, even though she is obligated to provide for them. This is based on the saying of the Prophet Muhammad (PBUH) regarding Zainab, the wife of Abdullah Ibn Mas'ud (may Allah be pleased with them): "Your husband and your children are more deserving of your charity" [Al-Bukhari]. And Allah Knows Best.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.