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.