What is the ruling on someone who eats or drinks thinking that the night is still present, then realizes that dawn has broken?
Whoever eats or drinks thinking that the night is still present, then later discovers that dawn has broken, must refrain from eating and drinking for the rest of the day out of respect for the sacred month. However, they must make up that day after Ramadan, and there is no sin upon them.
Is Fajr (dawn) Sunnah a confirmed one?
All praise be to Allah The Lord of The Worlds Of course, it is a confirmed Sunna which the Prophet (PBUH) used to offer in a regular basis. And Allah Knows Best.
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.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.