Examine these SQL statements that are executed in the given order: 

What will be the status of the foreign key EMP_MGR_FK? 

Answer options:

A. It will be enabled and immediate.
B. It will be enabled and deferred.
C. It will remain disabled and can be re-enabled manually.
D. It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.

C