AI and Prisma Schemas: Type-Safe Databases

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-prisma-schemas-r6

1. What is Prisma primarily used for in application development?

   1. A cloud storage service for backing up databases
   2. A programming language for building websites
   3. A version control system for code
   4. An ORM that provides type-safe queries from a single schema file

2. When you ask AI to add a many-to-many relation between User and Tag in your Prisma setup, what file are you actually modifying?

   1. The frontend React components
   2. The database file stored on disk
   3. The API endpoint configuration
   4. The Prisma schema file

3. Why is it important to read the SQL of a migration before running it on a database containing real data?

   1. Prisma requires a password to display SQL
   2. SQL cannot be read after generation
   3. Reading SQL is optional and has no practical benefit
   4. To check for errors and potential data loss

4. In Prisma terminology, what is a 'schema'?

   1. A database backup file
   2. A type of migration script
   3. An AI prompt template
   4. A single file that defines your data models and their relations

5. What is the purpose of a seed script that AI generates for your Prisma project?

   1. To convert data between different formats
   2. To populate the database with test data for local development
   3. To delete all existing data from the database
   4. To optimize database query performance

6. What specific warning might an AI give you when you're about to run a migration?

   1. That a column will be dropped and data will be lost
   2. That the code needs comments
   3. That the variable names don't match
   4. That the migration file is too large

7. Which of the following is NOT something AI can help you with when working with Prisma?

   1. Writing safe migrations that won't lose data
   2. Designing tables and setting up relations
   3. Generating seed scripts for testing
   4. Deploying directly to production without any human review

8. What happens to existing data in a database column when you remove that field from your Prisma schema and run a migration?

   1. The data is deleted when the column is dropped
   2. The data remains untouched
   3. The data is automatically moved to a new column
   4. The data is archived automatically

9. What is a database migration in the context of Prisma?

   1. A way to speed up slow queries
   2. A backup of the entire database
   3. Moving data from one database to another
   4. A script that changes the database schema structure

10. In a journal app with User, Entry, and Tag models, which two models would most likely need a relation defined between them?

    1. User and Entry in a one-to-many relationship
    2. Entry and the operating system
    3. Tag and the timestamp
    4. User and Tag directly in a one-to-one relationship

11. What is the main benefit of having type-safe queries when working with a database?

    1. The database automatically gets faster
    2. You never need to write tests
    3. Errors are caught at compile time before the code runs
    4. Backups become automatic

12. What would happen if you ran a migration on a production database without reviewing it first?

    1. The database would automatically create a backup
    2. Nothing would happen
    3. Prisma would refuse to run it
    4. You might accidentally drop important columns and lose data

13. Why might you ask AI to explain the difference between two Prisma migration commands?

    1. To make your code run faster
    2. To generate more migration files
    3. To automatically fix bugs
    4. To understand which command is appropriate for development versus production

14. If AI warns you that a migration will result in data loss, what should be your next step?

    1. Run the migration anyway to see what happens
    2. Delete the entire database to be safe
    3. Review the migration SQL carefully to understand the impact
    4. Ignore the warning and proceed

15. What makes Prisma different from writing raw SQL queries for database operations?

    1. There is no meaningful difference
    2. Prisma requires you to write more code
    3. Prisma provides type-safe queries that your editor can validate
    4. Raw SQL is faster in all cases