What is the best manner in distributing the meat of the Aqeeqah?
It is better to divide all of it as cooked meat amongst the poor and the needy. Dividing it into three portions is a Sunnah, but it is permissible to keep all of it provided that a portion, even a small one, is given to the poor and needy (one kilo for example).
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 disliked to clip one`s nails at night, and to burn them afterwards?
It is recommended to bury hair and nails that have been removed and to conceal them in the ground. As for burning nails, we have not found any specific prohibition against it, but adhering to what is supported by evidence—burying the nails—is preferable. 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].