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?

  1. A.

    DELETE FROM Accounts WHERE status = 'Inactive';

  2. B.

    DROP FROM Accounts WHERE status = 'Inactive';

  3. C.

    REMOVE FROM Accounts WHERE status = 'Inactive';

  4. D.

    TRUNCATE Accounts WHERE status = 'Inactive';

Attempted by 1321 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…