Which of the following will you use to accomplish the task?

You work as a Database Administrator for Domain.com. You create a database that has a table
named Students. The table is used for storing the records of students. Due to security reasons,
you want to permanently remove all data from the table without removing the table structure.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

You work as a Database Administrator for Domain.com. You create a database that has a table
named Students. The table is used for storing the records of students. Due to security reasons,
you want to permanently remove all data from the table without removing the table structure.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

A.
REMOVE TABLE FROM Students;

B.
DROP TABLE FROM Students;

C.
TRUNCATE TABLE Students;

D.
DELETE FROM Students;



Leave a Reply 0

Your email address will not be published. Required fields are marked *