Which operation adds a new row to a table?

Study for the SQL Basics Test. Improve your knowledge with multiple choice questions and detailed explanations. Prepare effectively to master SQL concepts!

Multiple Choice

Which operation adds a new row to a table?

Explanation:
Adding a new row to a table is done with the INSERT INTO statement. You specify the target table, the columns you’re filling, and the values for each column. For example: INSERT INTO employees (id, name, dept) VALUES (5, 'John Doe', 'Sales'); This creates a new row with those values. Other commands perform different actions: DELETE FROM removes existing rows, ALTER TABLE changes the table structure (like adding or removing columns), and a non-SQL command like Text isn’t used to manipulate data. So the statement that creates a new row is INSERT INTO.

Adding a new row to a table is done with the INSERT INTO statement. You specify the target table, the columns you’re filling, and the values for each column. For example: INSERT INTO employees (id, name, dept) VALUES (5, 'John Doe', 'Sales'); This creates a new row with those values. Other commands perform different actions: DELETE FROM removes existing rows, ALTER TABLE changes the table structure (like adding or removing columns), and a non-SQL command like Text isn’t used to manipulate data. So the statement that creates a new row is INSERT INTO.

More practice questions