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.