Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）

• A、 It would be automatically enabled and deferred.
• B、 It would be automatically enabled and immediate.
• C、 It would remain disabled and has to be enabled manually using the ALTER TABLE command.
• D、 It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.