Android Studio, how to keep track of quiz state and keep track of account scores?

I am designing a SQL quiz application in Android Studio and I have a login activity at the moment so there are separate accounts in SQLite database however I can't find my .db file currently. Once logged in you can access 6 main chapters, such as basics, joins and functions.

My first question is it possible to save the state that a user has left the quiz in so if you went into a chapter, for example functions, and completed the first two questions and then left the app, that when you log back in it will allow you to pick up at the same point when you go back to functions and it keeps that state even if you visit another chapter? I will be keeping track of the score in the database and I'm currently thinking of having validation so that you have to complete one question before moving on. The score value in the database for each chapter is incremented after each question so if you have completed the first two questions the database value for that chapter will be 2 if that helps, because I'm assuming that an IF statement on the chapter onclick may work.

My second question is there a way to keep track of the scores each user sets separate? At the moment I can't find my .db file but the login validation currently works so its keeping track of the username/passwords.