SQL UPDATE Statement Quiz

What is the primary purpose of the SQL UPDATE statement?

• To modify existing data in a table

• To create a new table

• To insert new data into a table

• To delete data from a table

Which clause is essential to ensure that only specific rows are updated in a SQL UPDATE statement?

• GROUP BY clause

• FROM clause

• WHERE clause

• ORDER BY clause

In the example of updating Mr. Bond's name, which column was changed?

• first_name

• code_name

• user_id

• last_name

When updating multiple columns in a SQL query, how are the changes separated?

• With periods

• With colons

• With commas

• With semicolons

What humorous element was included in the video to lighten the mood?

• A funny dance

• A database joke

• A SQL riddle

• A magic trick

How can you update the salary of all agents in the MI6 organization in a single query?

• By using a HAVING clause

• By using a WHERE clause

• By using a GROUP BY clause

• By using a JOIN clause

Which operator is used to update multiple specific user IDs at once?

• EXISTS

• BETWEEN

• IN

• LIKE

What happens if you omit the WHERE clause in an UPDATE statement?

• An error is thrown

• Only the first row is updated

• No rows are updated

• All rows in the table are updated

How can you increase all salaries by 10% using an UPDATE statement?

• By setting the salary to salary + 10

• By setting the salary to salary / 0.9

• By setting the salary to salary * 1.1

• By setting the salary to salary - 10

What SQL function can be used to calculate the total of all salaries?

• AVG

• COUNT

• SUM

• MAX