To remove only the records where the status = 'Inactive' from a table named…
PYQ KVS TGT/PGT 2026
To remove only the records where the status = 'Inactive' from a table named Accounts, which query is correct?
- A.
DELETE FROM Accounts WHERE status = 'Inactive';
- B.
DROP FROM Accounts WHERE status = 'Inactive';
- C.
REMOVE FROM Accounts WHERE status = 'Inactive';
- D.
TRUNCATE Accounts WHERE status = 'Inactive';
Attempted by 1321 students.
Sign up free to check your answer
Sign up freeLoading lesson…

