Question: 4 . Question 4 Why is the SQL LOAD command recommended over the IMPORT command for large amounts of data? 1 point The LOAD command

4.
Question 4
Why is the SQL LOAD command recommended over the IMPORT command for large amounts of data?
1 point
The LOAD command is not recommended for large amounts of data. IMPORT is a much better choice.
The LOAD command bypasses the database transactional logging mechanism, making it fast and efficient.
The LOAD command performs SQL INSERT statements for a group of rows and commits them periodically, saving transaction process time.
The LOAD command uses transactional logging, making it fast and efficient.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!