ExpertEasy1 markMultiple Choice
CPA · Question 23 · Area I: Information Systems
Which of the following SQL commands is used to remove a table and all its data permanently from the database?
Which of the following SQL commands is used to remove a table and all its data permanently from the database?
Answer options:
A.
DELETE FROM table_name
B.
DROP TABLE table_name
C.
TRUNCATE TABLE table_name
D.
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
B
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).
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...MediumQ02During a review of a client's cloud governance structure, an auditor notes that the client uses a...MediumQ03An auditor is evaluating the 'Processing Integrity' principle for a financial institution's loan ...HardQ04A company uses a batch processing system to update inventory records overnight. The 'Grandfather-...HardQ05During a walkthrough of the change management process, an auditor observes that the 'Developer' r...Medium