To remove only the records where the status = 'Inactive' from a table named…

2026

To remove only the records where the status = 'Inactive' from a table named Accounts, which query is correct?

Answer: A. DELETE FROM Accounts WHERE status = 'Inactive';

  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 840 students.

Show answer & explanation

Correct answer: A

Explore the full course: Bpsc

Loading lesson…