When performing a DELETE operation in SQL, what happens if you omit the WHERE clause?
- All rows are deleted
- An error is thrown
- No rows are deleted
- The table structure is modified
If you omit the WHERE clause in a DELETE operation, it will delete all rows in the table. This is known as a "truncation," and it's a risky operation.
Loading...
Related Quiz
- OOP in PHP stands for Object-Oriented ______.
- Which PHP function can be used to check if a function has been defined?
- What can be the potential issues when working with arrays in PHP?
- Which PHP function can be used to count the number of elements in an array?
- Which PHP function is particularly useful for validating and filtering data coming from insecure sources?