How is the Night Prayer (Qiyam al-Layl) performed?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Night Prayer (Qiyam al-Layl) refers to the voluntary (Nafl) prayers performed by a person after the Sunset prayer (Maghrib) and before the Dawn prayer (Fajr). As for Tahajjud, it is the voluntary prayer performed during the night specifically after waking up from sleep, as an act of devotion to Allah. Allah the Exalted says {what means}: "And from [part of] the night, pray with it [i.e., recitation] as additional worship for you." (Al-Isra/79). Thus, in terms of reward,Tahajjud is superior to voluntary prayers performed before sleeping. And Allah the Exalted knows best.
What is the ruling on eating or drinking during the second Adhan?
It is not permissible to eat or drink during the second Adhan because it announces the break of dawn and the obligation to start fasting. Allah Almighty says {what means}:"and eat and drink until you can discern the white streak of dawn against the blackness of night." [Al-Baqarah/187].
Whoever eats or drinks during this time invalidates their fast, and they must refrain from eating for the rest of the day and make up for the missed fast later.
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
Is the one who gives up on marriage because he can`t afford it considered sinful?
Marriage is desirable, but one who can`t afford it isn`t considered sinful. However, he should supplicate to Allah, and seek His forgiveness.