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 offer mandatory prayer while sitting?

All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.                                                                                                                                                                                                                            Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah Knows Best.

What is the ruling on someone who fainted while fasting?

 

What is the ruling on someone who eats or drinks while uncertain about the arrival of dawn, then later finds out that dawn had not yet broken?

If a person does this, their fast remains valid, as it is confirmed that they ate during the night. Similarly, if someone eats while uncertain and remains unsure whether they ate before or after dawn, their fast is still valid. This is based on the maxim of Sharia Law, which states: "Certainty is not removed by doubt." Certainty, here, is the presence of night, and the doubt concerns the arrival of dawn. Therefore, one relies on certainty and disregards doubt.