
Answer-first summary for fast verification
Answer: INSERT INTO my table VALUES ('a1',6,9.4)
## Explanation The correct answer is **A** because: 1. **INSERT INTO** is the standard SQL command for appending new records to an existing table 2. The syntax `INSERT INTO table_name VALUES (...)` is the correct way to insert a single row of data 3. The other options are incorrect because: - **B**: `UNION` is used to combine results from multiple SELECT statements, not to insert data - **C**: The syntax is reversed - `INSERT VALUES` should be `INSERT INTO` - **D**: `UPDATE` is used to modify existing records, not to insert new ones - **E**: This syntax is completely invalid for inserting data In Databricks Delta tables, you can use standard SQL `INSERT INTO` statements to append data to existing tables. The command preserves the existing data while adding new records.
Author: Keng Suppaseth
Ultimate access to all questions.
Which of the following SQL commands can be used to append the new record to an existing Delta table my.table?
A
INSERT INTO my table VALUES ('a1',6,9.4)
B
my table UNION VALUES ('a1', 6,9.4)
C
INSERT VALUES ('a1',6, 9.4) INTO my_table
D
UPDATE my_table VALUES ('a1', 6, 9.4)
E
UPDATE VALUES ('a1',6, 9.4) my table
No comments yet.