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
Question
Why is the SQL LOAD command recommended over the IMPORT command for large amounts of data?
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
