Question

Suppose an object-relational mapping(ORM) library syncs a database from source code models. What is an advantage of supporting migrations of existing tables?

1. To populate text fixtures

2. To guarantee test database schemas match the production schema

3. Faster creation of test databases

4. To allow additional constraints on the tables

Answer 1

Option (2) is the correct answer.

If an object-relational mapping(ORM) library syncs a database from source code models. The advantage of supporting migrations of existing tables is that it will ensure that the test database schemas match the production schemas.

Migration of existing tables will not provide text fixtures. It will not increase the test database creation speed. It will not allow additional constraints on the tables. So, other given options are incorrect.

Hope this helps.