If I open a query it starts an transaction and fetches the data. If I
exit the application is the transaction closed properly, or Do I have to
handle that myself to avoid Oldest transaction problems?

Regards

Sandeep