Question

Computer Information System(CIS): Define The Following Questions, And Give Example Of Each One Of Them.

A)- Data Definition Language (DDL)

B)- Data Manipulation Language (DML)

C)- Data Control Language(DCL)

Answer 1

A) DDL(DATA DEFINITION LANGUAGE): Data Definition language is used to define the structure of the database. By structure we mean the schema of the database. They define how the records will be stored in the table and how all the tables are structured in the database. Generally, the statements used to create the database and the schemas are known as DDL statements or data storage and definition language.

Some of the examples of DDL statements are CREATE, ALTER, DROP, etc.

B) DML(DATA MANIPULATION LANGUAGE): With Date manipulation language we make changes within the database or the schema. Generally, there are two types of DML's namely procedural DML's and non-procedural DML's. Procedural DML's defines what data are to be retrieved from the database and how to retrieve that whereas, non-procedural DML's only defines what data are to be retrieved and not how to get those data.

Some of the examples of DML statements are SELECT, INSERT, DELETE, etc.

C) DCL(DATA CONTROL LANGUAGE): Data control languages are used as syntaxes to control access to the data present inside the database or the schema.

Some of the examples of DML statements are GRANT, REVOKE, etc.