[Solved] Given the following Prisma schema change and migration command, what will happen?model User { id Int @id @default(autoincrement()) email String @unique name String? | NestJS

NestJS - Database with Prisma

Given the following Prisma schema change and migration command, what will happen?

model User {
  id    Int    @id @default(autoincrement())
  email String @unique
  name  String?
}

// Command run:
npx prisma migrate dev --name addNameField

AThe database schema remains unchanged

BAn error occurs because 'name' field is optional

CA migration file is created adding the optional 'name' field to User table

DThe User table is deleted and recreated

Step-by-Step Solution

Solution:

Step 1: Analyze schema change
The schema adds an optional 'name' field to the User model, which is a valid change.
Step 2: Understand migrate dev behavior
Running npx prisma migrate dev --name addNameField creates a migration file reflecting this change and applies it to the database.
Final Answer:
A migration file is created adding the optional 'name' field to User table -> Option C
Quick Check:
Optional field added = migration created [OK]

Quick Trick: Optional fields create migrations without errors [OK]

Common Mistakes:

Thinking optional fields cause errors
Assuming schema stays unchanged without manual DB update
Believing migrate dev deletes tables

Master "Database with Prisma" in NestJS

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Perf

More NestJS Quizzes

Given the following Prisma schema change and migration command, what will happen?

Step 1: Analyze schema change

Step 2: Understand migrate dev behavior

Final Answer:

Quick Check:

Want More Practice?