Lecture 17: SQLite and the Room ORM

Question 1

What is SQLite

Answer 1

A lightweight database that supports SQL style database syntax and a file based model

Question 2

The entire SQLite database is stored in ___ and queries simply __

Answer 2

• single file
• search and modify that file

Question 3

Why is SQL the preferred database for Android systems?

Answer 3

• file based model uses less resources
• supports enough sql syntax to make writing queries easy if youve worked with SQL before
• its public domain (free and open-sourced)

Question 4

SQLite only requires an ___ and a ___ it can read/write from

Answer 4

• SQLite library
• file

Question 5

What is an ARM

Answer 5

Object Relational Mapping (ORM)

An abstraction layer between the database and the code. The code interacts with the ORM instead of the database

Question 6

ORM makes it easier to mainain code ___ from the database

Answer 6

separetely

Question 7

Android provides built in ORM that it recommends you use when accessing databases known as ___

Answer 7

Room

Question 8

Underneath Room is still a ___, but you wont see it instead you ____

Answer 8

• SQLite database
• interact with classes ad methods defined within the ORM

Question 9

Rooms offer a easy way to set up ___ while also offering features you dont get in raw SQLite

Answer 9

databases, tables, and queries

Question 10

The Room ORM uses ___ layers to abstract the database

Answer 10

3

Question 11

Entities describe ___, define the ___, and allow ___

Answer 11

• singular rows
• column names of the table
• get/set of values

Question 12

What are Data Access Objects (DAOs)

Answer 12

Queries that return a collection of entities for the query

Question 13

What are the Room ORM layers?

Answer 13

• Room database
• Data Access Objects
• Entities