Oracle Exam 1Z0-497 Topic 3 Question 71 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 71
Topic #: 3

[All 1Z0-497 Questions]

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

ARedo is not generated while performing conventional path loads.

BOnly PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked,

CNo exclusive locks are acquired when the conventional path loads are performed.

DInstead of performing transactions, SQL*Loader directly writes data blocks to the data files.

EINSERT triggers are disabled before the conventional path load and re-enabled at the end of the load.

Show Suggested Answer

Suggested Answer: D

http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#CNCPT1254

(see database writer process (DBW))

by Winfred at Mar 02, 2023, 10:18 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Maddie

2 days ago

Option E sounds good to me. Disabling triggers during the load would make sense, so they don't get in the way of the data flow.

upvoted 0 times

...

Bobbye

5 days ago

Haha, Option C is clearly false. SQL*Loader is going to need to lock things down to get all that data loaded properly. No exclusive locks? Yeah, right!

upvoted 0 times

...

Albert

6 days ago

I think Option B is correct. Conventional path loads are all about getting data in quickly, so they probably only check the basic constraints.

upvoted 0 times

...

Fernanda

7 days ago

Option D is definitely true. SQL*Loader is all about speed and efficiency, so it makes sense that it would directly write data blocks instead of doing transactions.

upvoted 0 times

...