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 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.
Which hour coincides with the last third of the night?
This hour could be figured out by calculating the number of night hours which start at sunset, and end at dawn break, then the total is divided on three to get the result.
Should vowed fast be offered in consecutive days, or not?
Vowed fast should be offered in line with what was originally intended by the vow-maker, either consecutively, or not.