Final answer:
When a column is dropped from a database, typically both the constraints and indices associated with that column will be dropped as they are directly related to the column's existence.
Step-by-step explanation:
When a column is dropped from a database, typically, both the constraints and indexes associated with that column will also be dropped. This is because constraints like foreign keys, check constraints, and default values are directly related to the existence of the column. Similarly, indices that involve the column will no longer be relevant or valid once the column is removed, so they too are dropped.
If a database management system does support keeping constraints or indices after dropping a column, this would be non-standard behavior and would need to be explicitly configured, which is often not the case.
To answer the question directly, b) All constraints and indices will be dropped when a column is removed, under normal circumstances within most database systems.