Question

To permanently remove all the data from the STUDENT table, and you need the table structure in the future. Which single command performs this?

Select one:
a. DROP TABLE student;
b. DELETE * FROM student
KEEP STRUCTURE;
c. TRUNCATE TABLE student
KEEP STRUCTURE;
d. TRUNCATE TABLE student;

Answer 1

Answer:

ANS IS C TRUNCATE TABLE STUDENT KEEP STRUCTURE

Answer 2

Answer:

c or a command keeps it

Explanation: