×

DBMS Languages

User can access, update, delete, and store data or information in the database using database languages. The following are the databases languages in the database management system:

  1. Data Definition Language
  2. Data Manipulation Language
  3. Data Control Language
  4. Transaction Control Language
DBMS Languages

Data Definition Language (DDL)

Data Definition Language is used for defining the structure or schema of the database. It is also used for creating tables, indexes, applying constraints, etc. in the database.
The main purpose of DDL is to store the information of metadata like the number of schemas and tables, their names, indexes, constraints, columns in each table, etc. The result of Data Definition Language statements will be a set of tables which are stored in a special file called data directory or data dictionary.
This language is used by the conceptual schema to access and retrieve the records from/to the database respectively, where these records describe entities, relationship, and attributes.

 There are following Data Definition Languages (DDL) Commands:

  • Create: This command is used to create a new table or a new database.
  • Alter: This command is used to alter or change the structure of the database table.
  • Drop: This command is used to delete a table, index, or views from the database.
  • Truncate: This command is used to delete the records or data from the table, but its structure remains as it is.
  • Rename: This command is used to rename an object from the database.
  • Comment: This command is used for adding comments to our table.

Data Manipulation Language (DML)

Data Manipulation Language is a language used to access or manipulate the data in the database. In simple words, this language is used to retrieve the data from the database, insert new data into the database, and delete the existing data from the database.

Data Manipulation Language is mainlyof two types:

  • Procedural DML: This type of DML describes what data is to be accessed and how to get that data.
  • Declarative DML or Non-procedural DML: This type of DML only describes what data is to be accessed without specifying how to get it.

There are following Data Manipulation Language (DML) Commands:

  • Select: This command is used to retrieve or access the data from the database table.
  • Insert: This command is used to insert the records into the table.
  • Update: This command is used to change/update the existing data in a table.
  • Delete: This command is used to delete one or all the existing records from the table.

Data Control Language

DCL is used to access the stored or saved data. It is mainly used for revoking and granting user access on a database. In the Oracle database, this language does not have the feature of rollback. It is a part of SQL.

There are following Data Control Language (DCL) Commands:

  • Grant: This command allows user’s access privileges to the database.
  • Revoke: This command removes the accessibility of users from the database objects.

Transaction Control Languages

Transaction Control language is a language which manages transactions within the database. It is used to execute the changes made by the data manipulation language (DML) statements.

There are following Transaction Control Language (TCL) Commands:

  • Commit: This command is used to save the transactions in the database.
  • Rollback: This command is used to restore the database to that state which was last committed.

Related Posts:


Related Topics

Three Schema Architecture of DBMS

The three schema architecture describes how the data is represented or viewed by the user in the database. This architecture is also known as three-level architecture and is sometimes called...

3 minutes read.

Attributes in DBMS

What is Attribute? An attribute is an element in the database management system that describes the property or certain characteristics of the database entity. It is a crucial element of the...

3 minutes read.

Red-Black Tree Properties in DBMS

What is a Red-Black Tree? A red-black tree is a kind of self-balancing binary search tree. The extra bit that each node keeps denoting "color"-either "red" or "black"-is needed to keep...

3 minutes read.

ER Diagram for Banking System in DBMS

Entity Relationship Diagram Entity Relationship Diagrams, or ER Diagrams for short, are diagrams that show the relationships among entity sets that are stored in databases. Alternatively said, ER diagrams assist in...

3 minutes read.

Advantages of B-Tree in DBMS

A self-balancing search tree is the B-Tree. It is assumed that everything is in the main memory in most other self-balancing search trees (such as AVL and Red-Black Trees). We must...

3 minutes read.

Disadvantages of DBMS

Disadvantages of DBMS With the vast list of advantages, there are some following disadvantages or limitations of the database management system. 1. High Cost The high cost of software and hardware is the...

2 minutes read.

Data Models in DBMS

Data Models in DBMS Data models are the models explaining the logical structure of the database systems. They describe the entities, attributes, and the relationship among the data elements of the...

8 minutes read.

Normalization in DBMS: 1NF, 2NF, 3NF, BCNF & 4NF with Examples

Normalization is a technique of organizing the data in the database. It is a systematic approach which is used to remove or reduce data redundancy in the tables and remove the...

7 minutes read.

Advantages of Database Management System in DBMS

A database management system (DBMS) is a software tool that provides an interface for managing data stored in a database. Some advantages of using a DBMS include: data integration, data...

3 minutes read.

DBMS Architecture

This is the first step when creating a database management system. The architecture of a database management system plays an important role in determining the actual design and layout of...

4 minutes read.

BCNF in DBMS

BCNF stands for Boyce–Codd Normal Form. What is the Normal form? The normal form is mainly used to reduce the redundancy of the database tables. Or we can say that the normal form...

4 minutes read.

ACID Properties in DBMS

A transaction in a database has the following four properties, known as ACID properties. These properties are used to maintain the consistency of the database in the case of system failure and concurrent...

4 minutes read.

Super Key in DBMS

Super Key in DBMS: The super key is a column or a set of columns in the database table, which uniquely identifies the tuple or row of the same table....

2 minutes read.

Database for library management system

The database can be considered the container where the data or information can be stored electronically in a computer system. Most mobile applications and websites run our day-to-day activities by...

5 minutes read.

Inference Rules

Armstrong’s axioms are the complete set of basic inference rules used to infer all the functional dependencies on the relational database. An inference rule is a type of assertion that a user can...

2 minutes read.

Types of DBMS

Database Management System A software that is programmed to enable the user to create and maintain a database. Using DBMS, we can implement create, read, update and delete operations on the...

4 minutes read.

View Serializability in DBMS

View Serializability It is a type of serializability that can be used to check whether the given schedule is view serializable or not. A schedule called as a view serializable if it is view...

4 minutes read.

Relational Algebra in DBMS

Relational Algebra is a widely used procedural query language, which takes instances of one or more relation as an input and generates a new relation as an output. It uses a different...

6 minutes read.

Conversion of ER Diagram into Relational Model

After designing the Entity-Relationship diagram, you need to convert it into tables in the relational model. Because the relational model can be easily implemented by the Relational DBMS like Oracle, MySQL, etc....

2 minutes read.

Fundamentals Of Distributed DBMS

Fundamentals of DDBMS Here we are going to talk about the Fundamentals of DDBMS. But first, we need to know about Distributed databases to understand the Distributed Database Management System. Distributed Database: It is...

4 minutes read.