There is no clear indication in the AppStore, as to whether an app needs an active internet connection to work. The most reliable source is common sense and a look on the app size. If, for example, you download a navigation system which is only 50MB, than it probably requires an internet connection to work, as the maps will always be laeger than 50MB.