Which SQL statement can be used to remove a specific record identified by its primary key?
Options
-
A.
DELETE FROM students WHERE student_id = 101;
-
B.
DELETE FROM students WHERE student_id IS NULL;
-
C.
DROP TABLE students;
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
DELETE FROM students WHERE student_id = 101;
Detailed Explanation
- DELETE with primary key condition: Removes the record matching the specified primary key.
- Example: DELETE FROM students WHERE student_id = 101;
- Because a primary key uniquely identifies a record, this statement targets that particular row.
