Multiple choice technology databases

Which command lets you put data into more than one table using a single command?

  1. MERGE

  2. INSERT INTO MANY

  3. MULTIADD

  4. INSERT ALL INTO
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

INSERT ALL is an Oracle SQL command that enables inserting data into multiple target tables using a single statement. You specify multiple INTO clauses, each targeting a different table and optionally with different conditions. This allows efficient population of related tables without separate INSERT commands. MERGE operates on one table, while INSERT INTO MANY and MULTIADD are not valid SQL commands.

Keep practicing — related questions