To remove rows from a table in SQL, the correct statement to use is the DELETE statement. Let's go through each option to understand why it is correct or incorrect:
Option A) DROP - The DROP statement is used to delete an entire table or database, not specific rows within a table. Therefore, this option is incorrect.
Option B) REMOVE ROW - There is no specific SQL statement called REMOVE ROW. Therefore, this option is incorrect.
Option C) DELETE - The DELETE statement is used to remove one or more rows from a table based on a specific condition. It allows you to specify a WHERE clause to determine which rows should be deleted. This is the correct statement to use for removing rows from a table. Therefore, this option is correct.
Option D) DELETE ROW - There is no specific SQL statement called DELETE ROW. Therefore, this option is incorrect.
The correct answer is C) DELETE. This option is correct because the DELETE statement is used to remove one or more rows from a table based on a specific condition.