Introduction to Databases & SQL INTRODUCTION

SELF REVIEW: READ AND WRITE WITH SHAREDPREFERENCES

1. In this exercise, what was the name of the shared preferences key?

 2. In this exercise, what was the Composable used to change shared preference key value? 

3. In this exercise, MODE_WORLD_READABLE was used to access shared preferences. True or false?

4. What is the best way to describe SharedPreferences?

5. Which method would you call to obtain shared preferences in the Activity?  

6. In this exercise, you bound persisted state to the UI. When did you need to update the UI?   

KNOWLEDGE CHECK: INTRODUCTION TO SHAREDPREFERENCES

1. Which sentence best describes shared preferences?

2. Which shared preference methods can be used to put data in shared preferences? Select all that apply.

3. When are shared preference values vulnerable to data loss? Select all that apply.

4. How can a complex data type be stored in shared preferences?

5. Shared preferences is a temporary storage mechanism. True or false?

SELF REVIEW: READ AND WRITE WITH ROOM

1. In the last exercise, in which file did you need to place the Room dependencies?

2. Observe the following code:

  Button(  
    modifier = Modifier  
         .fillMaxWidth()  
         .padding(16.dp),  
     onClick = {  
         val newMenuItem = MenuItem(  
             id = UUID.randomUUID().toString(),  
             name = dishName,  
             price = priceInput.toDouble()  
        )  
        lifecycleScope.launch {  
           withContext(IO) {  
                  database.menuDao().saveMenuItem(newMenuItem)  
            }  
        }  
        dishName = ""  
        priceInput = ""  
    }  
) {  
    Text("Add dish")  
}  

What is Button doing here?

3. In this exercise the list of menu items was attached to the app state in the MainActivity.  True or false?

4. What is SQLite useful for? Choose the most appropriate answer. 

5. In this video the @Entity annotation is used to annotate what?     

6. In this exercise, the count on screen updated when you tapped the ‘quantity’ plus and minus buttons. Why did this happen? 

KNOWLEDGE CHECK: INTRODUCTION TO ROOM

1.  SQLite stores data in SQL tables using SQL statements. True or false?

2. Which of these does SQLite allow you to do? Select all that apply.

3. Which of these are major Room annotations? Select all that apply.

4. Which sentences correctly describe Room? Select all that apply.

5. What does the class do in the following code?

@Entity(tableName = "user_table") 
data class User ( 
    @PrimaryKey(autoGenerate = true) 
    var id: Int, 
    var name: String 
)	

MODULE QUIZ: SQL DATA IN ANDROID

1. Which shared preference methods should be used to save numeric data types? Select all that apply.

2. When are shared preference values persisted? Select all that apply.

3. Shared preferences is a persistent storage mechanism. True or false?

4. Which one of these are major Room annotations which are used to define Room data structure?

5. What does the DAO abbreviation stand for?

6. Which method is used to create a Room database?

7. Observe the following code snippet:

interface MenuDao {
@Query("SELECT * FROM MenuItem")
fun getAllMenuItems(): LiveData<List<MenuItem>>
}

Which language was used to query the data in the MenuDao interface?

8. Observe the following code snippet:

@Database(entities = [Player::class], version = 1)
abstract class AppDatabase: RoomDatabase() {
abstract fun playerDao(): PlayerDao
}

What does this class represent?

9. What is the right syntax for saving shared preferences value?

10. What is the right syntax for retrieving shared preferences instance?

CONCLUSION