ExamQuestions.com

Register
Login
Oracle Database 12c Essentials Exam Questions

Oracle

Oracle Database 12c Essentials

8 / 80

Question 8:

Which statement is true about loading data by using the conventional path of SQL*Loader? 

Answer options:

A. Redo is not generated while performing conventional path loads.
B. Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,
C. No exclusive locks are acquired when the conventional path loads are performed.
D. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
E. INSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.