Alchemy Day - 2

What is Alembic primarily used for?

• Query optimization

• Database schema migrations

• Database backups

• Data visualization

Alembic is written and maintained by the creators of:

• Django ORM

• SQLAlchemy

• Flask-SQLAlchemy

• PostgreSQL

Which of the following is NOT a feature of Alembic?

• Version control for database schema

• Command-line driven

• Auto-detection of all schema changes including column renames

• Works with MySQL, PostgreSQL, SQLite

Which command initializes Alembic in a project?

• alembic start

• alembic init alembic

• alembic setup

• alembic create

What file stores Alembic’s main configuration, including database URL?

• env.py

• alembic.ini

• script.py.mako

• versions/

Where are migration scripts stored by default?

• alembic.ini

• alembic/env.py

• alembic/versions/

• db/migrations/

Which function in a migration script applies schema changes?

• apply()

• upgrade()

• migrate()

• execute()

Which command generates a new migration script automatically from model changes?

• alembic revision -m "message"

• alembic revision --autogenerate -m "message"

• alembic upgrade head

• alembic migrate

What command is used to apply all migrations up to the latest version?

• alembic update

• alembic apply

• alembic upgrade head

• alembic run

Which command rolls back the most recent migration?

• alembic downgrade -1

• alembic undo

• alembic rollback

• alembic revert last