How to show SQLite Database table information in android application? What is the best way to do it?
Options
1) Use table layout with cursor
2) Use listView with cursor adapter
3) Use table layout with cursor adapter
4) use gridview with cursor adapter
Options
1) Pass different version number in incremental order, and put all upgrading code in onUpgrade() of helper class.
2) Pass different version number in incremental order, and put all upgrading code in onCreate() of helper class.
3) Pass different version number in any order, and put all upgrading code in onUpgrade() of helper class.
4) Pass different version number is decremental order, and put all upgrading code in onUpgrade() of helper class.
What is the difference between contentprovider and contentresolver?
Options
1) they are not at all related with each other
2) content provider is used to share private data with other applications, where as content-resolver communicates from client end with content provider.
3) content resolver is used to share private data with other applications, where as content-provider communicates from client end with content resolver.
4)content provider is used to store private data, where as content-resolver communicates from client end with content provider.
Options
1) possible. Content provider is also a component of android, so we can use intent to start it.
2) not possible. Using intent you can't trigger a content provider.
3) option 2 is correct because, we use content resolver to communicate with content provider
4)none
Can one application access other application's database directly?
Options
1) yes, it is possible
2) no, it is impossible
3) option 2 is right because, sqliteDB will be stored in internal memory app always. so other apps cannot access it.
4) Option 2 is wrong, because even if db tables are stored in internal memory, using Content Provider one can access database.
What is the purpose of SQLiteOpentHelper?
Options
1) A helper class to manage database creation, version management, and inserting/modifying/deleting/updating table data without loosing state of the previous data.
2)A helper class to insert/update/delete data into tables with loosing state of the previous data.
3)A helper class to manage database creation, upgrading and version management without loosing state of the previous data.
4) all of the above