If you are sure you do not need the data and want to remove thousands or millions of rows quickly,you can use the ____ command.
A) REMOVE
B) EMPTY
C) TRUNCATE
D) DELETE

Question

Quizplus · Accepted Answer

The TRUNCATE command is the best choice for quickly removing thousands or millions of rows from a table. It is more efficient than the DELETE command as it deallocates the data pages used by the table rather than removing each row one by one. The EMPTY command is not a valid SQL command. The REMOVE command is not a standard SQL command, and its behavior may vary depending on the database system used.

If You Are Sure You Do Not Need the Data