In this article we will learn about database query, SQL commands and its types. Database Query: Database Query is a request for data from a database. Usually, the request is to retrieve or manipulate data in a database. In simple words query is a question. It is similar to performing some sort of CRUD (Create, …
Let us understand the difference between delete truncate and drop table: Delete Truncate and Drop Table: Characteristics Delete Truncate Drop Command Type DML(Data Manipulation Language) DDL(Data Definition Language) DDL(Data Definition Language) Rollback transaction Can be rolled back Cannot be rolled back Cannot be rolled back Permanent delete Since it is DML does not remove records …