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
Not Null constraints are checked at insertion time. Any row that violates this constraint is rejected.
Unique constraints are verified when indexes are rebuilt at the end of the load. The index will be left in direct load state if a violation is detected. A primary key constraint is merely a unique-constraint on a not-null column.