ExpertHard1 markMultiple Choice
CPA · Question 71 · 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 FROM
B.
REMOVE TABLE
C.
DROP TABLE
D.
TRUNCATE TABLE
How to approach this question
DELETE = Empty the trash can. DROP = Throw away the trash can.
Full Answer
C.DROP TABLE✓ Correct
DROP TABLE
DROP TABLE removes the table definition and all data, indexes, triggers, constraints, and permission specifications for that table.
Common mistakes
Confusing DELETE (rows) with DROP (object).
Practice the full CPA ISC Practice Exam 4
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 environ...HardQ02An auditor is reviewing the Service Level Agreement (SLA) for a client using a public cloud provi...HardQ03A company uses an Infrastructure as a Service (IaaS) model. During an IT audit, the auditor disco...HardQ04An organization is implementing the COSO Enterprise Risk Management (ERM) framework to govern its...HardQ05During a walkthrough of an order-to-cash process, the auditor observes that the sales manager can...Hard