Unit – IV
Android Databases and Content Provider
2-Marks Answers
1. SQLite is a lightweight, serverless embedded database; unlike other DBMS it needs no server.
2. Room provides an abstraction over SQLite with safer, easier database access.
3. Realm is fast, easy to use, and doesn’t require SQL.
4. Firebase features: realtime DB, Firestore, auth, storage, notifications, analytics.
5. Best practices: use Room, background threads, transactions, close Cursor/DB.
6. SQLite uses: offline storage, caching API responses.
7. ContentValues stores data as key■value pairs for insert/update.
8. Key-value pairs: columnName → value.
9. Cursor provides read-only access to query results.
10. moveToFirst/Next/Position move the cursor in result rows.
11. Content Provider shares app data securely with other apps.
12. getColumnIndex returns column index for reading values.
5-Marks Answers
1. SQLite features: lightweight, serverless, portable, fast, ACID, single-file.
2. ContentValues methods: put(), clear(); stores column-value pairs.
3. Content Provider works via URIs, permissions, CRUD methods, and Cursor results.
4. Steps: extend ContentProvider, define URI, implement onCreate, query, insert, update, delete,
getType, register in manifest.
8-Marks Answers
1. Retrieve Cursor data: query → moveToFirst/Next → getString/getInt… → close cursor.
2. Content Provider enables data sharing via URIs, permissions, CRUD, ContentResolver.
3. URI identifies data: content://authority/path/id; essential for secure structured access.