Consider the following SQL query: DELETE FROM Employee WHERE Dept = 'HR'; What will happen if there are no employees in the HR department?

Question

Consider the following SQL query: 
 <SQL> 
 DELETE FROM Employee WHERE Dept = 'HR'; 
 What will happen if there are no employees in the HR department?

Answer

All rows in the table will be deleted

Answer

An error will occur

Answer

Rows with NULL values will be deleted

Answer

No rows will be deleted

Crowdly

Consider the following SQL query: <SQL> DELETE FROM Employee WHERE Dept = 'H...

Want instant access to all verified answers on moodle.nottingham.ac.uk?