How do I determine if the row has been inserted?

If no exception was thrown when calling execute() or commit(), it was inserted when you called commit().

Committing a transaction successfully is a guarantee from the database layer that the insert was written to disk.

you can get all the rows and see if its in there with:

SELECT * FROM TEST

But SQLite will give you an error message if it didnt work.