Snowpro Core · Free Practice Question Easy
Question 23
What does OVERWRITE parameter do with INSERT command?
- A It helps ignore any errors while inserting the values into the table.
- B It de-duplicates while inserting and skips the insert if there is an exact similar record in the table.
- C It drops the table, recreates, and inserts the values into the table.
- D It specifies that the target table should be truncated before inserting the values into the table.
Reveal correct answer
Correct answer: D
Explanation
OVERWRITE specifies that the target table should be truncated before inserting the values into the table. Note that specifying this option does not affect the access control privileges on the table.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
