I have several questions about database connection and database sessions. I assume questions below are apply to all databases (RDBMS).
In most of the cases, one database session is on one database connection. If client close the DB connection, will the DB session terminate straight away?
If the DB session contain a row level lock created via select for update query, will closing the DB connection without commit or rollback release the lock?
What is the impact if database statements are not close?