問題文
A load job has to copy the rows of last year from a live table into an archive table that already exists, and both tables have the same column list. Which single statement does that?
選択肢
- An INSERT statement whose values come from a subquery, because that form inserts as many rows as the subquery returns.
- An INSERT statement with a VALUES clause naming the source table, because that form reads the rows of that table one by one.
- A MERGE statement without a WHEN NOT MATCHED clause, because that form copies the source rows into the target as they are.
- A CREATE TABLE statement with a subquery, because that form fills a new table with the rows that a subquery returns.