How do you handle database migrations in CI/CD?

Question

Accepted Answer

CI/CD questions evaluate pipeline design, deployment strategies, artefact promotion, and balancing speed with safety in production releases. How do you handle database migrations in CI/CD? — explain the concept clearly, tie it to a real production scenario, and mention trade-offs