In SQL, which of the following is not a data manipulation language commands?

Question

A. DELETE

B. SELECT

C. UPDATE

D. CREATE

Answer 1

The correct answer is option D (Create). CREATE command is a data definition language command but not a data manipulation command. Data manipulation command is used to manipulate the data of those tables that are created by Data definition languages. CREATE, SELECT, UPDATE, LOCK, and MERGE are the data manipulation commands in SQL.

You can check out this SQL tutorial by Intellipaat to know the types of SQL commands such as DDL, DML, DQL, DCL, and TCL.

You can master these queries and become proficient in SQL queries by enrolling in an industry-recognized SQL certification.

Answer 2

Here correct option is D create. Create is data definition language

Here as per given options delete,update are the data manipulation language .

Select is data query language which we can even say that as data manipulation language.  So option a,b,c are not the answer for the given question