Which of the following is correct regarding SQL?
I – Truncate Table is a data manipulation language(DML) which concatenate two tables on the basis of common attribte.
II – Table is used to delete a table from database in SQL.
III – Data defination langauge (DDL) is used to create/delete/alter table defination/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) All statements are incorrect.


Answer: (C)

Explanation: I Truncate Table is a data definition language (DDL) which is used to delete some or all data from a table to reuse the space.
II – Drop Table is used to delete a table from a database or delete the whole database in SQL.
III – Data defination langauge (DDL) is used to create/delete/alter table defination/modify the integrity constraints.
IV – Data control language(DCL) is used for transaction/concurrency control/security purpose/access Control.
So, option (C) is correct.


Quiz of this Question