How Do You Add a Foreign Key to an Existing

question 102

Multiple Choice

How do you add a foreign key to an existing table created by another module?

• A) Create etc/db_schema.xml file with the table node and constraint child node Create etc/db_schema.xml file with the table node and constraint child node
• B) Run the command bin/magento setup:db-schema:upgrade <table> <constraint declaration> Run the command bin/magento setup:db-schema:upgrade <table> <constraint declaration>
• C) This can only be done with raw SQL in a Schema Patch file
• D) Create the etc/db_constraints.xml file and specify foreign key there in the constraint node Create the etc/db_constraints.xml file and specify foreign key there in the constraint node

---

Definitions:

Variable Costs

Expenses that vary in relation to the amount of activity or the quantity of output produced.

Fixed Costs

Expenses that remain constant regardless of production or sales volume, including rent, salaries, and insurance costs.

Operating Income

An indication of a company's profitability from its core business operations, excluding income and expenses from unusual, non-operational activities.

Contribution Margin

The amount by which a product's sales price exceeds its variable costs, contributing to covering fixed costs and generating profit.