What is the ruling on reciting verses from the Qur'an over water, drinking it, and using it to break magic spells, heal illnesses, or burn jinn?
There is no harm on reciting verses of the Holy Qur'an over water and use it for cure. And Allah Knows Best.
What is teh ruling on thoughtless oath?
One who swears by Allah unintentionally and isn`t determined to fulfill his oath, nothing is due on him. Allah, The Almighty, Says (What means): "God will not call you to account for thoughtlessness in your oaths, but for the intention in your hearts; and He is Oft-forgiving, Most Forbearing." [Al-Baqarah/225]. However, it is dispraised for a Muslim to swear frequently.
What is the ruling of Sharia on looking at one`s Mahram women?
All perfect praise be to Allah, the Lord of the worlds. I testify that there is none worthy of worship except Allah and that Muhammad, sallallahu ‘alayhi wa sallam, is His slave and Messenger.
A Mahram man (man impermissible for a woman to marry) is permitted to look at what usually appears from his Mahram women (women impermissible for a man to marry) while doing their daily housework, with the exception of their private parts. And Allah The Almighty 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].