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 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.
Should one fulfill his vow of donating an animal to the poor and needy with one sheep although he had repeated the vow several times?
Each vow has to be fulfilled, and repeating the words of the same vow for confirmation renders its fulfillment obligatory as one vow. As for multiple vows, they have to be fulfilled as well.
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.