DBMS Question
What is the use of DROP command and what are the differences between DROP, TRUNCATE and DELETE
commands?

Question

DBMS Question

What is the use of DROP command and what are the differences between DROP, TRUNCATE and DELETE
commands?

Accepted Answer

DROP command is a DDL command which is used to drop/delete the existing table, database, index or view from the
database.

The major difference between DROP, TRUNCATE and DELETE commands are :

DROP and TRUNCATE commands are the DDL commands which are used to delete tables from the database and
once the table gets deleted, all the privileges and indexes that are related to the table also get deleted. These 2
operations cannot be rolled back and so should be used only when necessary.

DELETE command, on the other hand, is a DML Command which is also used to delete rows from the table and this
can be rolled back.

Top CGI Group Application Support Engineer interview questions & answers

Popular interview questions of Application Support Engineer