Which of the following statement(s) is/are correct regarding SQL?

  • I. Truncate Table is a data manipulation language (DML) which is used to delete some or all data from a table to reuse the space.
  • II. Delete Table is used to delete a table from database in SQL.
  • III. Data definition language (DDL) is used to create, delete, alter table definition, modify the integrity constraints.
  • IV. Data control language (DCL) is used for transaction, concurrency control, security purpose, access Control.

(A) II and III
(B) I III and IV
(C) III and IV
(D) None of the above


Answer: (C)

Explanation: Statement (I) is false because, truncate Table is a data definition language (DDL) which is used to delete some or all data from a table to reuse the space.

Statement (II) is also false, because drop Table is used to delete a table from a database or delete the whole database in SQL.

Only statement (III) and (IV) are correct.

Quiz of this Question


  • Last Updated : 30 Nov, 2018

Share your thoughts in the comments