MySQL Data Manipulation Language Quiz

What is the purpose of the SELECT statement in MySQL?

• To insert data into a table in a database.

• To update data in a table in a database.

• To delete data from a table in a database.

• To retrieve data from one or more tables in a database.

Which keyword is used to update data in a MySQL table?

• UPDATE

• MODIFY

• DELETE

• INSERT

How can you delete all records from a MySQL table?

• DELETE FROM table_name;

• TRUNCATE TABLE table_name;

• DROP TABLE table_name;

• REMOVE FROM table_name;

What is the syntax for inserting data into a MySQL table?

• INSERT INTO table_name VALUES (value1, value2, value3, ...)

• INSERT INTO table_name (value1, value2, value3, ...) VALUES (column1, column2, column3, ...)

• INSERT INTO (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)

• INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)

Which MySQL function is used to count the number of rows in a table?

• COUNT()

• MAX()

• SUM()

• MIN()

What is the purpose of the WHERE clause in a SELECT statement?

• To sort the rows returned by the query in ascending order.

• To specify the columns to be included in the query result.

• To join multiple tables together in the query result.

• To filter the rows returned by the query based on a specified condition.

How can you update multiple columns in a MySQL table?

• UPDATE table_name SET column1=value1, column2=value2 WHERE condition;

• UPDATE table_name SET column1=value1 WHERE condition; UPDATE table_name SET column2=value2 WHERE condition;

• UPDATE table_name SET column1=value1, column2=value2, ... WHERE condition;

• UPDATE table_name SET column1=value1, column2=value2, ...;

Which keyword is used to delete specific records from a MySQL table?

• REMOVE

• ERASE

• DELETE

• DROP

What is the purpose of the VALUES keyword in an INSERT statement?

• To specify the columns to be inserted into the values of a table.

• To define the data type of the values to be inserted.

• To specify the order in which the values should be inserted into the columns of a table.

• To specify the values to be inserted into the columns of a table.

Which MySQL function is used to concatenate two or more strings?

• CONCATENATE()

• CONCAT()

• MERGE()

• JOIN()