Snowpro Core · Free Practice Question Easy
Question 79
Inserting data into a table in Snowflake without specifying column names requires that the number and order of values match the table's column structure exactly.
-
A
False
-
B
True
Reveal correct answer
Correct answer: B
A.
This is incorrect because not matching the number or order of columns and values would result in an error when inserting data.
B.
When using the INSERT INTO command without specifying column names, the values must exactly match the table’s column structure in both order and number. This ensures that each value is placed into its corresponding column correctly.
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.
