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.