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].
Is it permissible for one to give the Zakah (obligatory charity) to his indebted brother?
It is permissible for one to give the Zakah to his brother if he was indebted, or poor.
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.
I made a vow "If the Israeli troops retreated out of Gaza strip I will buy a cake from a certain bakery" and it happened. Am I obliged to buy from the same bakery?
You are obliged to buy from the same bakery. And Allah Knows Best.