Question 58

Which of the following SQL command will delete the structure as well as content of a table EMPLOYEE ?

  1. AERASE EMPLOYEE;
  2. BDELETE FROM EMPLOYEE;
  3. CDROP EMPLOYEE;
  4. DDROP TABLE EMPLOYEE;
Show answerHide answer

Correct answer: (D) DROP TABLE EMPLOYEE;

Explanation

DROP TABLE EMPLOYEE removes the table's structure and all its data. DELETE FROM only removes rows and keeps the structure.

From DSSSB TGT Computer Science Practice Set 3

This is question 58 of DSSSB TGT Computer Science Practice Set 3. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.