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
Share your thoughts in the comments
Please Login to comment...