Which SQL command is used to remove specific records from a table?
Options
-
A.
DROP
-
B.
DELETE
-
C.
ALTER
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
DELETE
Detailed Explanation
- DELETE removes records from a table.
- The WHERE clause can be used to delete selected rows.
- Without WHERE, all records are deleted, but the table structure remains.
OOps! You are currently offline.