You should start looking in:
If you can't see the Library folder in Finder, click here how to show hidden files and folders in Mac OS X.
To access the applications in the Simulator, pick the iOS version you are using e.g.:
Go to Applications folder and pick the hashed folder name that contains your application e.g.
For the SQLite Database, it should be inside the "Documents" folder with the extension ".sqlite" e.g.:
You can use Liya app (it's free) to open the sqlite database.
/Users/[current user]/Library/iPhone Simulator/
If you can't see the Library folder in Finder, click here how to show hidden files and folders in Mac OS X.
To access the applications in the Simulator, pick the iOS version you are using e.g.:
/Users/[current user]/Library/iPhone Simulator/6.1
Go to Applications folder and pick the hashed folder name that contains your application e.g.
/Users/[current user]/Library/iPhone Simulator/6.1/Applications/2ABAAFD5-71B0-478A-BEBD-13BA56AA03D7
For the SQLite Database, it should be inside the "Documents" folder with the extension ".sqlite" e.g.:
/Users/[current user]/Library/iPhone Simulator/6.1/Applications/2ABAAFD5-71B0-478A-BEBD-13BA56AA03D7/Documents/myapp.sqlite
You can use Liya app (it's free) to open the sqlite database.