Data Engineering Associate with Databricks Practice Exam

Which of the following is the correct SQL command to insert data into a table?

1. INSERT INTO students VALUES (1, "Omar")

2. INSERT INTO students (1, "Omar")

3. INSERT students VALUES (1, "Omar")

4. ADD INTO students (1, "Omar")

The correct answer is: INSERT INTO students VALUES (1, "Omar")

The SQL command for inserting data into a table typically follows the syntax that specifies the table name and the values to be inserted. The correct option showcases this structure properly by using the keyword "INSERT INTO" followed by the specified table name (students) and then the "VALUES" keyword, which provides the actual data being inserted (1, "Omar"). This command aligns with the standard SQL syntax, where the "INSERT INTO" command is used to add new records into a specified table, and "VALUES" clearly indicates what data is being populated into the corresponding columns of that table. In this case, it implies that the integer "1" would be the first column value and "Omar" is the second column value being inserted into the students table. Other options deviate from the correct syntax. Some omit critical elements, such as the "VALUES" keyword or the need to specify which columns are being inserted. These discrepancies result in invalid SQL commands, illustrating why the answer chosen correctly adheres to the proper SQL structure.