Which of the following SQL commands would be used to remove both the data and the table structure of a table named STUDENT?
A) DROP TABLE STUDENT;
B) DELETE TABLE STUDENT;
C) REMOVE TABLE STUDENT;
D) SELECT * FROM STUDENT THEN DROP;
E) DELETE FROM STUDENT;

Question

Quizplus · Accepted Answer

The DROP TABLE command is used to remove both the data and the table structure of a table in SQL. The correct syntax for removing a table is "DROP TABLE table_name;". Therefore, choice A is the correct answer as it uses the correct syntax to drop the table named STUDENT.

Choices B, C, D, and E are incorrect. 
-B) DELETE command is used to remove only data from the table, not the table structure itself.
-C) REMOVE command is not a valid SQL command and does not exist.
-D) SELECT command is used to retrieve data from a table, not to remove a table.
-E) DELETE command is used to remove data from a table, but not the table structure itself.

Which of the Following SQL Commands Would Be Used to Remove