What happens if the DELETE command is used without a WHERE clause?AOnly the first row will be deletedBAll rows in the table will be deletedCNo rows to delete

Sure, let's break down the question step by step:

1. Understanding the DELETE Command:

   • The DELETE command in SQL is used to remove rows from a table.

2. The Role of the WHERE Clause:

   • The WHERE clause specifies which rows should be deleted. It acts as a filter to target specific rows.

3. DELETE Command Without WHERE Clause:

   • If the DELETE command is used without a WHERE clause, it means there is no filter applied to the deletion process.

4. Effect of No WHERE Clause:

   • Without a WHERE clause, the DELETE command will not have any condition to limit the rows being deleted.

5. Outcome:

   • As a result, all rows in the table will be deleted because there is no condition to restrict the deletion to specific rows.

So, the correct answer is:

B. All rows in the table will be deleted