Unit 3 Database - Implementation - SQL INSERT

Question 1

What is the purpose of the INSERT query in SQL?

Answer 1

The INSERT query is used to add a row or multiple rows to a table.

Question 2

What is the basic syntax of an INSERT query?

Answer 2

INSERT INTO table [(column1, column2, column3, ...)] VALUES (value1, value2, value3, ...);

Question 3

What happens when you execute the following query? INSERT INTO user VALUES (7914, ‘SuperPlayer’, ‘soupRpalya’, ‘31/12/2018’);

Answer 3

A new row is added to the user table with the specified values.

Question 4

How can you insert multiple rows at once in SQL?

Answer 4

By using a single INSERT statement with multiple sets of values, separated by commas.

Question 5

How can you specify the column order when inserting data?

Answer 5

By explicitly listing the column names in the INSERT statement before the VALUES keyword.

Question 6

Why is it important to ensure that column names and values match when inserting data?

Answer 6

To prevent errors and ensure data is inserted into the correct columns in the correct order.

Question 7

What should you do after inserting data into a table?

Answer 7

Use a SELECT query to verify that the data has been added correctly.