Location of data file?

Where is the database data file located locally (I'm quite sure it is stored locally)? Also, how can I tell if it is located locally or if its stored in iCloud