SQL Data Manipulation

What does the UPDATE statement do in SQL?

• It retrieves data from a database table.

• It modifies data in a database table.

• It deletes data from a database table.

• It creates a new database table.

Which SQL statement is used to insert new data into a database?

• UPDATE

• INSERT

• SELECT

• DELETE

What is the syntax for the UPDATE statement in SQL?

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

• UPDATE table_name SET column1 = value1, column2 = value2, ... SET column3 = value3

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

• UPDATE table_name SET column1 = value1 WHERE condition

Avery, Grace, and Aria are working on a project where they have to manage a database. They have some unnecessary data in their database. Which SQL statement should they use to delete this data from their database?

• REMOVE

• DELETE

• ERASE

• CLEAR

What are aggregate functions in SQL?

• Aggregate functions in SQL are functions that perform calculations on a set of values and return a single value.

• Aggregate functions in SQL are functions that perform calculations on a set of values and return no value.

• Aggregate functions in SQL are functions that perform calculations on a single value and return a set of values.

• Aggregate functions in SQL are functions that perform calculations on a set of values and return multiple values.

Which aggregate function is used to calculate the average value of a column in SQL?

• COUNT

• MAX

• AVG

• SUM

What is the purpose of the GROUP BY clause in SQL?

• The GROUP BY clause in SQL is used to sort the data in ascending order.

• The GROUP BY clause in SQL is used to filter rows based on a condition.

• The GROUP BY clause in SQL is used to update values in a table.

• The purpose of the GROUP BY clause in SQL is to group rows with the same values in specified columns.

Which SQL statement is used to filter data based on a condition?

• ORDER BY

• WHERE

• SELECT

• GROUP BY

What is the syntax for the INSERT statement in SQL?

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

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

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

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

What is the purpose of the WHERE clause in SQL?

• To filter rows based on specified conditions.

• To join multiple tables.

• To sort rows in ascending order.

• To update data in a table.