This quiz is designed to test your understanding of SQLite databases and their integration with Android applications. It covers essential concepts like database tables, schemas, primary keys, and the use of SQL for data manipulation. Additionally, it explores how SQLite is embedded within Android, how to interact with databases using ADB shell, and introduces the Room persistence library for more efficient database management. Use this quiz to review key topics and ensure you have a solid grasp of SQLite usage in Android development.
1.
Why is SQLite a suitable choice for mobile applications?
2.
Which Android command-line tool is used to interact with an Android device or emulator for debugging purposes?
3.
Why is it necessary for each table in Android's SQLite database to have a primary key named '_id'?
4.
How is SQLite different from other relational database management systems like Oracle or SQL Server?
5.
How is data typically stored in an SQLite database on an Android device?
6.
Which statement is used to create a new table in an SQLite database?
7.
Why is SQLite considered 'embedded'?
8.
What does the 'autoincrement' keyword ensure when used with a primary key in SQLite?
9.
Which of the following is true about the Structured Query Language (SQL)?
10.
What happens if an Android app creates a database without defining a primary key?
11.
What is the function of the .tables command in SQLite?
12.
What is the role of the 'Room' persistence library in Android?
13.
What role does a database schema play in a database?
14.
Which SQL command is used to add a new row into a table?
15.
Which SQL statement would you use to retrieve all rows from a table named 'contacts'?
16.
Which of the following is used to uniquely identify a row in a database table?
17.
What is the purpose of the 'autoincrement' keyword when defining a primary key in SQLite?
