It depends on what you want your app to do. If your app doesn't need a server connection, it will run fine with no Network connection. We recently wrote an app for measuring pain a patient is experiencing and allowing them to text their Dr. This works completely offline, without any need for a Network Connection.
If you have a Server side that the app communicates with to retrieve data, then if you need it to work without a Network Connection use SQLITE. The app synchs with the server when there is a Network Connection, but can run offline with NO Network Connection.