In standard SQL administration, which statement is used to enable or disable all triggers on a specific table in one step?

Introduction / Context:Database triggers can enforce business rules and maintain audit trails. Administrators sometimes need to enable or disable all triggers on a table—for example, during bulk loads or maintenance. This question checks the correct SQL statement typically used for that task.

Given Data / Assumptions:

• A relational database with tables that may have multiple triggers.
• The intention is to enable or disable all triggers on one table in a single statement.
• Vendor syntax varies, but the widely recognized form uses ALTER TABLE.

Concept / Approach:Common implementations (e.g., Oracle) use statements such as: ALTER TABLE table_name DISABLE ALL TRIGGERS or ALTER TABLE table_name ENABLE ALL TRIGGERS. The controlling verb is ALTER TABLE, not a separate ‘‘ALTER TRIGGERS’’ object.

Step-by-Step Solution:

Verification / Alternative check:Database documentation typically shows ENABLE/DISABLE trigger operations under ALTER TABLE semantics; there is no general SQL standard ‘‘ALTER TRIGGERS’’ statement operating at table scope.

Why Other Options Are Wrong:

• ALTER TRIGGERS: not a standard DDL command for batch-enabling/disabling at table scope.
• MODIFY TRIGGERS IN TABLE: not valid SQL syntax.
• All of the above: false because only ALTER TABLE is correct.
• None of the above: incorrect, since ALTER TABLE is correct.

Common Pitfalls:Assuming a non-standard verb exists; in practice, manage trigger state through ALTER TABLE with vendor-specific clauses.

Final Answer:ALTER TABLE