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 it necessary for each table in Android's SQLite database to have a primary key named '_id'?
2.
Which SQL command is used to add a new row into a table?
3.
What happens if an Android app creates a database without defining a primary key?
4.
How is SQLite different from other relational database management systems like Oracle or SQL Server?
5.
Why is SQLite a suitable choice for mobile applications?
6.
Which SQL statement would you use to retrieve all rows from a table named 'contacts'?
7.
Which statement is used to create a new table in an SQLite database?
8.
How is data typically stored in an SQLite database on an Android device?
9.
What is the function of the .tables command in SQLite?
10.
What is the purpose of the 'autoincrement' keyword when defining a primary key in SQLite?
11.
Which of the following is true about the Structured Query Language (SQL)?
12.
Which Android command-line tool is used to interact with an Android device or emulator for debugging purposes?
13.
What does the 'autoincrement' keyword ensure when used with a primary key in SQLite?
14.
What role does a database schema play in a database?
15.
What is the role of the 'Room' persistence library in Android?
16.
Which of the following is used to uniquely identify a row in a database table?
17.
Why is SQLite considered 'embedded'?
