Evaluate the following SQL statements that are issued in the given order:

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.
出自:Oracle认证