With creation of a database connection object from within a Python program, a unique session with database starts.

The sql query upon execution via established database connection returns the result in multiple chunks.

The cursor.rowcount returns how many rows have been so far retrieved through fetch..() methods from the cursor.

A DELETE or UPDATE or INSERT query requires commit() to reflect the changes in the database.