What is the ruling on staring at the Holy Ka'abah?
All perfecy 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.
Staring/looking at the Holy Ka'abah is an act of worship even if this took place while performing a prayer, since Al-Baihaqee stated that the Prophet (PBUH) said: " Staring at the Holy Ka'abah is an act of devotion." [Sho'aab Al-Imaan]. 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].
What is the Du`a (supplication) of Istikhara (guidance prayer)?
O Allah, I consult You as You are All-Knowing and I appeal to You to give me power as You are Omnipotent, I ask You for Your great favor, for You have power and I do not, and You know all of the hidden matters. O Allah! If you know that this matter (then he should mention it) is good for me in my religion, my livelihood, and for my life in the Hereafter, or he said: "for my present and future life" then make it (easy) for me. And if you know that this matter is not good for me in my religion, my livelihood and my life in the Hereafter, or he said: "for my present and future life" then keep it away from me and take me away from it and choose what is good for me wherever it is and please me with it."
What is the difference between Tahajjud prayer and night prayer, and do they have a particular Witr prayer other than that of Isha (evening prayer)?
Tahajjud and Qiyam-Al-Lail (night prayer) are two words for the same meaning which is offering voluntary prayer at night after sunset, but before dawn break. However, Tahajjud is offered after waking up; whereas, Qiyam-Al-Lail is permissible before sleeping, or after it. Therefore, every Tahajjud is a Qiyam, but not every Qiyam is a Tahajjud. Moreover, there is no specified Witr for both of them, but Witr after Isha is by itself the Witr of Qiyam, and it is a Sunnah to postpone it until after Qiyam if the worshiper thought that he was most probably going to wake up in order to offer it, but if he wasn`t sure of waking up, then he is at liberty to offer it before going to bed as was reported in the Prophet`s Hadith.