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 the mother to give her children from the Zakah (obligatory charity) of her money?
It is permissible for the mother to give her children from the Zakah of her money if they are Zakah-eligible recipients, and she isn`t obliged to provide for them.
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
Is it permissible to use the term 'Al-Jalalah' (Majesty) for anyone other than Allah, The Exalted?
In the Arabic language, a man of dignity and reverence is described as 'Jaleel' (noble), and similarly, an elder or a woman of dignity may be described as 'Jaleelah'. In such contexts, one may use the title 'His Majesty' or 'Her Majesty.' However, the Majesty of Allah, The Exalted, is unlike the majesty of humans, just as His hearing is not like our hearing, and His sight is not like our sight. And Allah The Almighty Knows Best.