- Trending Categories
- Data Structure
- Operating System
- C Programming
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What are different types of DBMS languages?
Once data is stored or filled it requires manipulation like insertion, deletion, updating, and modification of data. For these operations a set of languages are provided by the database management system (DBMS). So, the database languages are used to read, update and store data in the database.
The different types of DBMS languages are as follows −
Data Definition Language (DDL) − Create, Drop, Truncate, Rename.
Data Manipulation language (DML) − Select, Insert, Delete, Update.
Data Control Language (DCL) − Revoke, Grant.
Transaction Control Language (TCL) − Rollback, Commit.
The DBMS languages are pictorially represented as follows −
Data Definition Language (DDL)
It is a language that allows the user to define the data and their relationship to other types of data. The DDL commands are: Create, Alter, Rename, Drop, Truncate.
Data Manipulation Language (DML)
It is a language that provides a set of operations to support the basic data manipulation operation on data held in the database. The DML commands are: Insert, delete, update, select, merge, call.
Data Control Language (DCL)
DCL is used to access the stored data. It is mainly used for revoke and grant the user access to a database. The DCL commands are: Grant, Revoke.
Transaction Control Language (TCL)
TCL is a language which manages the transactions within the database. It is used to execute the changes made by the data manipulation language statements. The TCL commands are: Commit, Rollback.
- What are the different types of DBMS?
- What are different types of recoverability of schedules(DBMS)?
- What are the different types of schedules in DBMS?
- What are the different computer languages?
- What are different types of interrupts?
- What are Different Types of Testing?
- What are the different types of psychotherapy?
- What are different types of eating disorders?
- What are the different types of ISDN?
- What are different types of finite automata?
- What are the Different Types of Marketing?
- What are different hashing methods in DBMS?
- What are the different types of LED available?
- What are different types of constants in C++?
- What are different types of quotes in Python?