Introduction to SQL, Room, and Flow

1. True or False: INSERT, UPDATE, and DELETE can be used to modify multiple rows in a data table.

   True

   False

2. Which of the following are true about the DISTINCT keyword?

   Choose as many answers as you see fit.

   The DISTINCT keyword can be used in an aggregate function.

   The DISTINCT keyword can be used to determine all the unique values in a column.

   The DISTINCT keyword can only be used when selecting a single column.

   The DISTINCT keyword can be used as part of the WHERE clause.

3. Which order of clauses in a SELECT statement is correct?

   WHERE, LIMIT, ORDER BY, GROUP BY

   WHERE, LIMIT, GROUP BY, ORDER BY

   WHERE, ORDER BY, GROUP BY, LIMIT

   WHERE, GROUP BY, ORDER BY, LIMIT

4. True or False: The ORDER BY clause returns results in descending order by default.

   True

   False

5. Fill-in-the-blanks

   Enter one or more words to complete the sentence.

   SQL stands for ___.

6. True or False: You can use the * to select all columns in a data table

   True

   False

7. A primary key allows for:

   Choose as many answers as you see fit.

   Databases to represent relationships between tables.

   Rows in one table to reference rows in another table.

   Contents of individual rows in a table to be unique.

   A unique identifier for each row in a table.

8. Fill-in-the-blanks

   Enter one or more words to complete the sentence.

   Room is an ORM Library. ORM stands for ___.

9. Which of the following are true about ListAdapter?

   Choose as many answers as you see fit.

   A ListAdapter is not a RecyclerViewAdapter, and thus, cannot be used with a RecyclerView.

   Like a RecyclerViewAdapter, a ListAdapter uses a ViewHolder class.

   ListAdapter makes use of DiffUtil.

   The implementation for areContentsTheSame() compares only the IDs between entities, whereas areItemsTheSame() compares all the properties.

10. Which of the following is false about using flow?

    Returning a regular type, like a list, from a DAO function won't allow your app to respond to data changes.

    Data returned as a flow can be processed using the collect() function.

    A flow can only be accessed from a coroutine.

    Flow is a Kotlin feature that returns multiple asynchronous computed values.

error_outline An error occurred when grading the quiz. Please try again.