You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader
direct path load method to perform this task. The table in which you plan to load data in an
important table having various integrity constraint defined on it.
Which constraints will remain enabled by default during this operation? (Choose all that apply.)
A.
CHECK
B.
UNIQUE
C.
NOT NULL
D.
PRIMARY KEY
E.
FOREIGN KEY
during a direct path load, NOT NULL, UNIQUE and PRIMARY KEY constraints remain in an enabled mode — hence they are not re-enabled at the end since they were never disabled.
you have to specify the REENABLE keyword to enable the constraints automatically after the load.