The (metabase) application database depends on your setup; if you've only deployed the java file and nothing else then you should find the application database in the same directory as the java file; I guess you'll just need to configure a driver for accessing the file via your preferred method / query tool.
For the activity queries, once you've accessed your application database, maybe start with this: