ExpertMedium1 markMultiple Choice
CPA · Question 29 · Area I: Information Systems
Which SQL command is used to remove a table and all its data permanently from the database?
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 TABLE
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.
Practice the full CPA ISC Practice Exam 2
82 questions · hints · full answers · grading
More questions from this exam
Q01A service organization provides a cloud-based payroll platform where clients access the software ...MediumQ02An auditor is reviewing the backup strategy for a financial institution that requires a Recovery ...HardQ03During a walkthrough of the change management process, an auditor observes that developers have w...MediumQ04An auditor is reviewing a SQL query used to generate a list of active customers for a marketing c...HardQ05Which of the following entities is considered a 'Covered Entity' under the HIPAA Privacy Rule?Medium