AI and Database Migrations: Change Your Schema Safely

End-of-lesson check

15 questions · take it digitally for instant feedback at tendril.neural-forge.io/learn/quiz/end-builders-ai-coding-AI-and-database-migrations-teen

1. What is the primary purpose of a database migration?

   1. To store new user data in a table
   2. To connect two different databases together
   3. To delete old backup files
   4. To describe and apply a change to the database structure

2. What are the 'up' and 'down' steps in a migration?

   1. Up creates a backup, down restores it
   2. Up connects to the database, down disconnects
   3. Up applies the change, down undoes the change
   4. Up adds a column, down removes it

3. Why should every schema change be made through a migration instead of a manual edit?

   1. Manual edits work better on large databases
   2. Migrations can be rolled back if something breaks
   3. Manual edits are faster for small changes
   4. Migrations are required by law

4. What is a rollback in the context of database migrations?

   1. Deleting the entire database
   2. Undoing a migration using the 'down' step
   3. Creating a new backup
   4. Adding more data to tables

5. What is a schema in database terms?

   1. A tool for connecting to databases
   2. A type of database backup
   3. A programming language for databases
   4. The structure defining tables, columns, and relationships

6. What is an ORM, and how does it relate to migrations?

   1. A tool that manages database connections and can generate migrations
   2. A type of database that stores images
   3. A backup service for cloud databases
   4. A programming language for writing queries

7. Why does AI warn you to back up production before running a destructive migration?

   1. AI always warns about backups regardless of the operation
   2. Backups make the migration run faster
   3. Backups are required by the database software
   4. If something goes wrong, you can restore the data

8. What is a data migration, and when is it needed?

   1. A migration that deletes old databases
   2. A migration that creates new tables
   3. A migration that connects two databases
   4. A migration that fills in default values for existing rows

9. What does it mean for a migration to be 'repeatable'?

   1. It can be run multiple times on the same database
   2. It automatically fixes errors
   3. It never needs to be undone
   4. It works on any database type

10. What would happen if you manually edited a database schema without using a migration?

    1. The change would be applied to all environments instantly
    2. The change would be faster but couldn't be easily tracked or rolled back
    3. The database would automatically create a backup
    4. Nothing would change—the edit wouldn't work

11. If you ask an AI to 'Write a Prisma migration that adds a streak column to the User table,' what will the AI generate?

    1. A new user with that column
    2. Both up (apply) and down (undo) steps for adding the column
    3. A video tutorial on migrations
    4. A script to delete all users

12. Which of these best describes why AI helps with writing migrations?

    1. AI generates correct syntax so you don't have to memorize it
    2. AI runs the migrations for you automatically
    3. AI makes migrations run faster
    4. AI is required by database software

13. What is a destructive migration?

    1. A migration that adds new optional columns
    2. A migration that cannot be rolled back
    3. A migration that only works in development
    4. A migration that removes data or drops tables

14. Why do old rows in a database need special attention when you add a new column?

    1. They may not have a value for the new column
    2. They become corrupted
    3. They cannot be modified anymore
    4. They automatically get deleted

15. What is Prisma?

    1. A type of database
    2. A backup service
    3. A programming language
    4. A migration tool (an ORM) that can generate migrations