Which of the Following SQL Commands Would Be Used to Remove

question 24

Multiple Choice

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

• A) DROP TABLE STUDENT;
• B) DELETE TABLE STUDENT;
• C) REMOVE TABLE STUDENT;
• D) SELECT * FROM STUDENT THEN DROP;
• E) DELETE FROM STUDENT;

---

Definitions:

Capitalized Trucks

The value of trucks owned by a company that is treated as an asset on the balance sheet and depreciated over time.

Sum-Of-The-Years'-Digits Method

A method of accelerated depreciation calculating annual depreciation expense based on the sum of the years' digits of an asset's useful life.

Double-Declining-Balance Method

An accelerated depreciation method that expenses more of an asset’s cost closer to the beginning of its usable life.

Depreciable Asset Accounting

The accounting process that involves allocating the cost of a tangible asset over its useful life.