Question

which of these is not a valid category of sql command a) ddl b) dcl c) dcl and) dml

Answer 1

Answer:

I guess the answer is

dcl

Answer 2

Question:

Which of the following is not a type of SQL statement?

(A) Data Manipulation Language (DML)

(B) Data Definition Language (DDL)

(C) Data Control Language (DCL)

(D) Data Communication Language (DCL)

Answer:

(D) Data Communication Language (DCL) is the correct answer.

Explanation:

DML(Data Manipulation Language) => Used for adding , deleting and modifying data in database. Example - SELECT , INSERT , DELETE , UPDATE etc.

DDL(Data Definition Language) => Used for creating and modifying database objects such as tables, indexes, and users. Example - CREATE , ALTER and DROP.

DCL(Data Control Language) => Used for controlling the access to data stored in a database.Example -  GRANT , REVOKE

Above three are all related to Database Management.

Data Communication Language (DCL) => Transmission of data between computers to exchange data.