I have created a gameScore.db file, i have been trying to locate this file on my pc and i never found it.
Im wondering how this database file structure work. Is there any interface for my Database such as SQL PLUS or something that i can access to view my databases
If I understand your question, each app you run in the Corona simulator has a “sandbox” folder where it stores .db files your app creates. To open this file, in the Simulator select File > Show Sandbox Folder.
You can then use a SQLite viewer like this one to view your db content.