Answer to Question #246159 in Databases | SQL | Oracle | MS Access for Michael Sampson

Question

Identify and with practical examples give the different types of languages that are available in the DBMS?

Answer 1

The types of languages available in DBMS include:

1. Data Definition Language (DDL):

DDL is used in defining the pattern or structure of the database. 

Commands used in DDL include: truncate, alter, rename, drop, create and comment.

2. Data Manipulation Language (DML): 

DML is used to access and manipulate data in the database.

Commands used in DML include: insert, delete, update, select, and merge.

3. Data Control Language (DCL):

DCL is used in retrieving the stored data from the database.

Commands used in DCL include: revoke and grand.

4. Transaction Control Language (TCL):

TCL is used in running the changes made by the DML statement.

Commands used in DCL include: commit and rollback.