For Individuals For Educators

Ace your certifications with Practice Exams and AI assistance.

Browse Exams
For Educators
Blog

Privacy Policy
Terms of Service
Cookie Policy
Support

AWS SAA Exam Prep
PMI PMP Exam Prep
CPA Exam Prep
GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

Practice CPA®CPA ISC Practice Exam 2Question 29

Medium1 markMultiple Choice

Area I: Information SystemsData ManagementSQLArea I

CPA · Question 29 · Area I: Information Systems

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

Answer options:

A.

DELETE TABLE

B.

REMOVE TABLE

C.

DROP TABLE

D.

TRUNCATE TABLE

How to approach this question

Distinguish between DELETE (data), TRUNCATE (data, fast), and DROP (object + data).

Full Answer

C.DROP TABLE✓ Correct

DROP is a DDL (Data Definition Language) command that deletes the table schema and data. DELETE is DML (Data Manipulation Language).

Common mistakes

Confusing DELETE and DROP.

Question 28 All questions Question 30

Practice the full CPA ISC Practice Exam 2

82 questions · hints · full answers · grading

Sign up free Take the exam

More questions from this exam

Q01A service organization provides a cloud-based payroll platform where clients access the software ...Medium Q02An auditor is reviewing the backup strategy for a financial institution that requires a Recovery ...Hard Q03During a walkthrough of the change management process, an auditor observes that developers have w...Medium Q04An auditor is reviewing a SQL query used to generate a list of active customers for a marketing c...Hard Q05Which of the following entities is considered a 'Covered Entity' under the HIPAA Privacy Rule?Medium

View all 82 questions →