Question

Which SQL Query below is correct for deleting all records from 'Products' table having product names starting with 'M'?

• A. DELETE FROM Products WHERE ProductName LIKE 'M%';
• B. REMOVE FROM Products WHERE ProductName LIKE 'M%';
• C. DROP FROM Products WHERE ProductName IS 'M%';
• D. REMOVE FROM Products WHERE ProductName IS 'M%';

Hint:

Remember:
- Use DELETE to remove records (rows) from a table.
- Use DROP to remove the entire table structure from the database.
- Use LIKE for wildcard matches, never use the IS operator with wildcards!

Answer 1

The Correct Option is A

Step 1: Understanding the Concept:
To remove specific rows from a table based on a condition, the ‘DELETE‘ command combined with a ‘WHERE‘ clause using the ‘LIKE‘ operator is used.

Step 2: Detailed Explanation:
1. ‘DELETE FROM‘ is the correct SQL keyword to remove rows.
2. ‘REMOVE‘ is not a standard SQL command for row deletion.
3. ‘DROP‘ is used to remove an entire table or database structure, not individual records.
4. The ‘%‘ wildcard is used with ‘LIKE‘ to match any string starting with 'M'.

Step 3: Final Answer:
The correct query is (A).