Which of the following SQL commands is used to remove a table and all its data permanently from the database?

Answer options:

DELETE FROM table_name

DROP TABLE table_name

TRUNCATE TABLE table_name

REMOVE TABLE table_name

How to approach this question

Distinguish between removing data (DELETE/TRUNCATE) and removing the object itself (DROP).

Full Answer

B.DROP TABLE table_name✓ Correct

DROP TABLE is a DDL (Data Definition Language) command that removes the table definition and all its data. DELETE and TRUNCATE are used to remove data while keeping the table structure.

Common mistakes

Confusing DELETE (rows) with DROP (object).

Question 22 All questions Question 24

Practice the full CPA ISC Practice Exam 3

82 questions · hints · full answers · grading

More questions from this exam

Q01A CPA is advising a client who is migrating their legacy on-premise ERP system to a cloud-based s...Medium Q02During a review of a client's cloud governance structure, an auditor notes that the client uses a...Medium Q03An auditor is evaluating the 'Processing Integrity' principle for a financial institution's loan ...Hard Q04A company uses a batch processing system to update inventory records overnight. The 'Grandfather-...Hard Q05During a walkthrough of the change management process, an auditor observes that the 'Developer' r...Medium

View all 82 questions →