Test Your MySQL INSERT Knowledge with This Quiz

Progress

True / False

The MySQL "INSERT" statement can be used to add new rows to a table.

True False

The primary purpose of the "INSERT" statement in MySQL is to add new rows to a table.

True / False

In MySQL, the "INSERT" statement can insert multiple rows into a table with a single command.

True False

MySQL allows inserting multiple rows in a single "INSERT" statement by separating the values for each row with a comma.

True / False

The "INSERT" statement in MySQL requires all column names to be specified.

True False

It is not mandatory to specify all column names in an "INSERT" statement if the table has default values for the columns or allows NULL values.

True / False

The MySQL "INSERT IGNORE" statement inserts a new row but ignores errors for duplicate key violations.

True False

"INSERT IGNORE" in MySQL inserts a new row while ignoring duplicate key violations and other errors that would normally cause the statement to fail.

True / False

The "INSERT INTO ... SELECT" statement in MySQL can copy data from one table to another.

True False

The "INSERT INTO ... SELECT" statement allows copying data from one table and inserting it into another table in MySQL.

True / False

In MySQL, you cannot use subqueries within an "INSERT" statement.

True False

MySQL supports using subqueries within an "INSERT" statement to determine the data to be inserted.

True / False

The "INSERT ON DUPLICATE KEY UPDATE" statement in MySQL updates existing rows when a duplicate key is found.

True False

"INSERT ON DUPLICATE KEY UPDATE" in MySQL inserts a row if the key does not exist, or updates the row if the key already exists.

True / False

MySQL allows inserting data into a view using an "INSERT" statement.

True False

MySQL allows inserting data into a view, provided the view is updatable and the insert operation complies with the view's constraints.

True / False

The "INSERT" statement in MySQL can be used with stored procedures.

True False

MySQL allows "INSERT" statements to be used within stored procedures to add rows to a table.

Q10

True / False

The MySQL "INSERT DELAYED" statement improves performance by delaying the insert operation until the table is free.

True False

As of MySQL 5.6.6, the "INSERT DELAYED" statement is deprecated and does not improve performance as it once did. The statement was removed in MySQL 8.0.

Q11

Single Choice

Which of the following is the correct syntax to insert a new row into a MySQL table?

INSERT INTO table_name (column1, column2) VALUES (value1, value2); INSERT table_name VALUES (value1, value2); INSERT INTO table_name SET column1=value1, column2=value2;INSERT table_name SET (column1, column2) = (value1, value2);

The correct syntax to insert a new row into a MySQL table is INSERT INTO table_name (column1, column2) VALUES (value1, value2);.

Q12

Single Choice

Which MySQL keyword is used to insert data into a table?

ADD INSERT INCLUDEPUT

The INSERT keyword is used in MySQL to add new rows of data to a table.

Q13

Single Choice

If you want to insert data into only specific columns of a table, which part of the MySQL INSERT statement is optional?

Column names Table name VALUESDatabase name

The column names are optional if you are inserting data into all columns of the table. However, if you want to insert data into specific columns, you must specify the column names.

Q14

Single Choice

What will happen if you try to insert a duplicate value into a MySQL table's primary key column?

The duplicate value will be inserted MySQL will throw an error. MySQL will overwrite the existing value.The duplicate value will be ignored.

In MySQL, the primary key column must contain unique values. Inserting a duplicate value into the primary key column will result in an error.

Q15

Single Choice

How can you insert multiple rows into a MySQL table with a single INSERT statement?

INSERT INTO table_name (col1, col2) VALUES (val1, val2) AND (val3, val4) INSERT INTO table_name (col1, col2) VALUES (val1, val2), (val3, val4); INSERT INTO table_name (col1, col2) VALUES (val1, val2) OR (val3, val4);INSERT INTO table_name (col1, col2) VALUES val1, val2, val3, val4;

In MySQL, you can insert multiple rows into a table by specifying each set of values in the VALUES clause separated by commas.

Q16

Single Choice

Which MySQL clause can be used with the INSERT statement to update existing records instead of inserting new ones if a duplicate key is found?

ON DUPLICATE KEY UPDATE IF DUPLICATE KEY UPDATE ON UPDATE KEYIF DUPLICATE UPDATE

The ON DUPLICATE KEY UPDATE clause is used to update existing records in MySQL when a duplicate key is found during an INSERT operation.

Q17

Single Choice

Which MySQL statement can be used to insert data from one table into another table?

INSERT INTO table1 SELECT * FROM table2; INSERT INTO table1 SET * FROM table2; INSERT INTO table1 GET * FROM table2;INSERT INTO table1 PICK * FROM table2;

The INSERT INTO ... SELECT ... statement is used to insert data from one table into another table in MySQL.

Q18

Single Choice

How do you insert data into a MySQL table and return the last inserted ID?

INSERT INTO table_name (col1) VALUES (val1); SELECT LAST_INSERT_ID(); INSERT INTO table_name (col1) VALUES (val1); SELECT MAX(ID); INSERT INTO table_name (col1) VALUES (val1); RETURN LAST_INSERT_ID();INSERT INTO table_name (col1) VALUES (val1); SELECT NEW_ID();

The LAST_INSERT_ID() function in MySQL returns the auto-increment ID generated by the last INSERT statement.

Q19

Single Choice

Which MySQL statement allows you to insert data and ignore errors related to duplicate keys?

INSERT IGNORE INTO table_name (col1) VALUES (val1); INSERT IGNORE DUPLICATE INTO table_name (col1) VALUES (val1); INSERT INTO IGNORE table_name (col1) VALUES (val1)INSERT INTO table_name IGNORE (col1) VALUES (val1);

The INSERT IGNORE statement in MySQL inserts data and ignores errors related to duplicate keys, continuing the operation without interruption.

Q20

Single Choice

What is the purpose of the REPLACE INTO statement in MySQL, and how does it differ from the INSERT statement?

REPLACE INTO inserts a new row or replaces an existing row if a duplicate key is found; INSERT only inserts a new row. REPLACE INTO only inserts a new row; INSERT inserts a new row or replaces an existing row. REPLACE INTO deletes a row with a duplicate key before inserting a new one; INSERT only inserts a new row.REPLACE INTO appends data to an existing row; INSERT only inserts a new row.

The REPLACE INTO statement in MySQL inserts a new row or replaces an existing row if a duplicate key is found, effectively removing the old row and adding the new one. In contrast, the INSERT statement only inserts a new row.

Q21

Multiple Choice

Identify the correct SQL statement to insert a new row into a table with all columns specified.

SQL Code

INSERT INTO employees (employee_id, first_name, last_name, department)
VALUES (1, 'John', 'Doe', 'HR');

INSERT INTO employees (employee_id, first_name, last_name, department) VALUES (1, 'John', 'Doe', 'HR'); INSERT INTO employees (employee_id, first_name, last_name) VALUES (1, 'John', 'Doe', 'HR'); INSERT INTO employees VALUES (1, 'John', 'Doe', 'HR');INSERT INTO employees VALUES ('John', 'Doe', 'HR');

The INSERT INTO statement is used to insert a new row into the employees table. All columns are explicitly listed and provided with corresponding values.

Q22

Multiple Choice

Choose the correct SQL statement to insert a new row with only specific columns specified.

SQL Code

INSERT INTO products (product_name, price)
VALUES ('Laptop', 1500);

INSERT INTO products (product_name, price) VALUES ('Laptop', 1500); INSERT INTO products VALUES ('Laptop', 1500); INSERT INTO products (product_name, price) VALUES ('Laptop', 1500, 'Electronics');INSERT INTO products (product_name, price, category) VALUES ('Laptop', 1500);

This SQL statement inserts a new row into the products table, only specifying the product_name and price columns, while other columns will take default or NULL values.

Q23

Multiple Choice

Determine the correct SQL statement to insert multiple rows into a table in a single query.

SQL Code

INSERT INTO orders (order_id, customer_id, order_date)
VALUES (1, 101, '2024-01-01'),
(2, 102, '2024-01-02');

INSERT INTO orders (order_id, customer_id, order_date) VALUES (1, 101, '2024-01-01'), (2, 102, '2024-01-02'); INSERT INTO orders (order_id, customer_id, order_date) VALUES (1, 101, '2024-01-01'); INSERT INTO orders (order_id, customer_id, order_date) VALUES (2, 102, '2024-01-02'); INSERT INTO orders VALUES (1, 101, '2024-01-01'), (2, 102, '2024-01-02');INSERT INTO orders (order_id, customer_id, order_date) VALUES ((1, 101, '2024-01-01'), (2, 102, '2024-01-02'));

This SQL statement inserts multiple rows into the orders table in a single query, each set of values is enclosed in parentheses and separated by commas.

Q24

Multiple Choice

Which SQL statement correctly uses INSERT IGNORE to avoid inserting a row if a duplicate key exists?

SQL Code

INSERT IGNORE INTO users (user_id, username, email)
VALUES (1, 'jdoe', 'jdoe@example.com');

INSERT IGNORE INTO users (user_id, username, email) VALUES (1, 'jdoe', 'jdoe@example.com'); INSERT INTO users (user_id, username, email) IGNORE VALUES (1, 'jdoe', 'jdoe@example.com'); INSERT INTO users VALUES (1, 'jdoe', 'jdoe@example.com') IGNORE;INSERT OR IGNORE INTO users (user_id, username, email) VALUES (1, 'jdoe', 'jdoe@example.com');

The INSERT IGNORE statement is used to insert a row, but if a duplicate key conflict occurs (e.g., the user_id already exists), the insert is ignored without an error.

Q25

Multiple Choice

Select the correct SQL statement to insert data into a table using a SELECT statement.

SQL Code

INSERT INTO archive_orders (order_id, customer_id, order_date)
SELECT order_id, customer_id, order_date
FROM orders
WHERE order_date < '2023-01-01';

INSERT INTO archive_orders (order_id, customer_id, order_date) SELECT order_id, customer_id, order_date FROM orders WHERE order_date < '2023-01-01'; INSERT INTO archive_orders VALUES (SELECT order_id, customer_id, order_date FROM orders WHERE order_date < '2023-01-01'); INSERT INTO archive_orders SELECT * FROM orders WHERE order_date < '2023-01-01';INSERT INTO archive_orders (order_id, customer_id, order_date) SELECT * FROM orders WHERE order_date < '2023-01-01';

The INSERT INTO...SELECT statement is used to insert data from one table into another table based on a query.

Q26

Multiple Choice

Determine the correct SQL statement to insert a row and return the AUTO_INCREMENT value of the inserted row.

SQL Code

INSERT INTO transactions (amount, transaction_date)
VALUES (100, '2024-01-01');
SELECT LAST_INSERT_ID();

INSERT INTO transactions (amount, transaction_date) VALUES (100, '2024-01-01'); SELECT LAST_INSERT_ID(); INSERT INTO transactions (amount, transaction_date) VALUES (100, '2024-01-01') RETURN AUTO_INCREMENT; INSERT INTO transactions (amount, transaction_date) VALUES (100, '2024-01-01') GET LAST ID;INSERT INTO transactions (amount, transaction_date) VALUES (100, '2024-01-01'); SELECT AUTO_INCREMENT();

The LAST_INSERT_ID() function is used to retrieve the AUTO_INCREMENT value generated by the most recent INSERT operation.

Q27

Multiple Choice

Which SQL statement correctly inserts data into a table with a BLOB column?

SQL Code

INSERT INTO images (image_id, image_data)
VALUES (1, LOAD_FILE('/path/to/image.jpg'));

INSERT INTO images (image_id, image_data) VALUES (1, LOAD_FILE('/path/to/image.jpg')); INSERT INTO images (image_id, image_data) VALUES (1, '/path/to/image.jpg'); INSERT INTO images (image_id, image_data) VALUES (1, BLOB('/path/to/image.jpg'));INSERT INTO images (image_id, image_data) VALUES (1, FILE('/path/to/image.jpg'));

The LOAD_FILE function is used to read the contents of a file and insert it into a BLOB column.

Q28

Multiple Choice

Select the correct SQL statement to insert data into a table with a TIMESTAMP column that uses the current time as a default.

SQL Code

INSERT INTO log_entries (log_id, log_message)
VALUES (NULL, 'System rebooted');

INSERT INTO log_entries (log_id, log_message) VALUES (NULL, 'System rebooted'); INSERT INTO log_entries (log_id, log_message, log_time) VALUES (NULL, 'System rebooted', NOW()); INSERT INTO log_entries (log_id, log_message) VALUES ('System rebooted');INSERT INTO log_entries (log_id, log_message) VALUES ('System rebooted', CURRENT_TIMESTAMP);

When the TIMESTAMP column has a default value of CURRENT_TIMESTAMP, inserting NULL or omitting the column will insert the current time.

Q29

Multiple Choice

Determine the correct SQL statement to insert a row using default values for unspecified columns.

SQL Code

INSERT INTO employees (employee_name)
VALUES ('Jane Smith');

INSERT INTO employees (employee_name) VALUES ('Jane Smith'); INSERT INTO employees VALUES ('Jane Smith'); INSERT INTO employees (employee_name) DEFAULT VALUES ('Jane Smith');INSERT INTO employees (employee_name) VALUES ('Jane Smith', DEFAULT);

This SQL statement inserts a new row with the employee_name specified, while other columns will take their default values or NULL if not specified.

Q30

Multiple Choice

Identify the correct SQL statement to insert data into a table with a generated column.

SQL Code

INSERT INTO orders (product_id, quantity)
VALUES (101, 2);

INSERT INTO orders (product_id, quantity) VALUES (101, 2); INSERT INTO orders (product_id, quantity, total_price) VALUES (101, 2, 200); INSERT INTO orders (product_id, quantity) VALUES (101, 2, GENERATED ALWAYS);INSERT INTO orders (product_id, quantity) DEFAULT VALUES (101, 2);

When inserting data into a table with a generated column, the values for the generated column are calculated automatically based on the expression defined during table creation.

MySQL Database Quiz Questions