Machine-translated by Google. Questions are authored in English.
Top

Discussion

When using the SQL INSERT statement:

  • A.rows can be modified according to criteria only.
  • B.rows cannot be copied in mass from one table to another only.
  • C.rows can be inserted into a table only one at a time only.
  • D.rows can either be inserted into a table one at a time or in groups.

Answer: D

Correct answer: rows can either be inserted into a table one at a time or in groups.

INSERT takes either a VALUES clause for a single row or a SELECT in place of it, in which case every row the query returns is inserted. The second form is how a table is populated in bulk from another, and it is why loading data does not require a row-by-row loop.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.