Question

SQL commands can be classified into three types. Which isNOT an SQL command type?
1 DDL

2 DML

3 DGL

4 DCL

Answer 1

Answer:

DGL

Explanation:

SQL stands for structured query language which is used to interface with the database.

Let discuss the options:

1. DDL: This comes in the category of SQL and it stands for data definition language. This allows using CREATE, DELETE, DROP, ALTER, etc. of the table in the database.

2. DML: This comes in the category of SQL and it stands for data manipulation

language. This allows the user to use the INSERT, DELETE, UPDATE command which help to manipulate the data in the table.

3. DGL: This is not a part of SQL.

4. DCL: This comes in the category of SQL and it stands for data control language which allows the user to use ALTER PASSWORD, GRANT, REVOKE like command which helps the user to control access the data in the database.

Therefore, the correct answer is DGL.