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].
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 for a Muslim to slaughter an Aqeeqah on behalf of someone else, and offer it to him as a gift?
In principle, the guardian is the one who should offer the Aqeeqah (the sheep slaughtered on the seventh day from the child`s birth) because he is obliged to provide for the newborn, and it is impermissible for anyone else to slaughter it on his behalf unless with his consent. However, it is permissible for a person to offer the sheep, or its price as a gift to the guardian of the newborn, and then the latter can slaughter it, or deputies someone else to do that on his behalf.
Is it permissible for the children of a deceased father to settle his debt from the Zakah (obligatory charity) money due on them?
It is impermissible to use the Zakah of one`s money for settling the debts of the deceased. However, children should settle the debts of their deceased parents out of filial piety. And Allah Knows Best.