UPDATE without WHERE (danger) in SQL - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

What is the output after running this UPDATE?

Consider a table Employees with columns id, name, and salary. Initially, the table has these rows:

id | name    | salary
---+---------+--------
1  | Alice   | 5000
2  | Bob     | 6000
3  | Charlie | 7000

What will be the salaries of all employees after running this query?

UPDATE Employees SET salary = 10000;

SQL

UPDATE Employees SET salary = 10000;

A Only Alice's salary is 10000, others unchanged

B All employees have salary 10000

C Only Bob and Charlie have salary 10000, Alice unchanged

D No salaries changed

💡 Hint

Think about what happens if you don't specify a WHERE clause in an UPDATE statement.

Without a WHERE clause, the UPDATE affects all rows in the table. So every employee's salary is set to 10000.

🧠 Conceptual

intermediate

Why is running UPDATE without WHERE dangerous?

Which of the following best explains the danger of running an UPDATE statement without a WHERE clause?

A It updates all rows, possibly overwriting data unintentionally

B It causes a syntax error and the query fails

C It only updates the first row and ignores the rest

D It locks the table permanently

💡 Hint

Think about what happens when no filter is applied to an update.

Without a WHERE clause, the UPDATE affects every row, which can overwrite data unintentionally and cause data loss.

📝 Syntax

advanced

Which UPDATE statement will update only Bob's salary to 8000?

Given the Employees table, select the correct UPDATE statement that changes only Bob's salary to 8000.

A UPDATE Employees WHERE name = 'Bob' SET salary = 8000;

B UPDATE Employees SET salary = 8000;

C UPDATE Employees SET salary = 8000 WHERE id;

D UPDATE Employees SET salary = 8000 WHERE name = 'Bob';

💡 Hint

Remember the correct order of clauses in an UPDATE statement.

The correct syntax is UPDATE table SET column = value WHERE condition;. Option D follows this correctly and targets only Bob.

❓ query_result

advanced

What happens if you run UPDATE without WHERE on a table with 0 rows?

Consider an empty table Products with columns id and price. What is the result of running:

UPDATE Products SET price = 10;

What will be the state of the table after this query?

A The table remains empty with 0 rows

B All rows have price set to 10

C The table is deleted

D Syntax error occurs

💡 Hint

Think about how UPDATE affects rows when there are none.

If the table has no rows, UPDATE affects zero rows. The table remains empty.

🔧 Debug

expert

Why did this UPDATE without WHERE cause data loss?

A developer ran this query:

UPDATE Orders SET status = 'shipped';

They intended to update only orders with id > 100. What happened and why?

A The query failed due to missing WHERE clause

B Only orders with id > 100 were updated automatically

C All orders had their status changed to 'shipped' because no WHERE clause was used

D Only the first order was updated

💡 Hint

Recall what happens when UPDATE is run without a filter.

Without a WHERE clause, the UPDATE affects every row, causing unintended data changes and data loss.