You intend to import data from an external source into a table. You must make sure that the tasks below are achieved:
* The rows that fail the foreign key constraints during import are inserted into a separate table.
* Even if the import encounters rows that fail foreign key constraints, it is successfully completed.
So what should you do?
A.
An AFTER trigger has to be used
B.
CHECK constraints have to be used
C.
An INSTEAD OF trigger has to be used
D.
During the import process disable the foreign keys