Prerequisite – DDL, DQL, DML, DCL and TCL Commands
DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL.
DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL.
Difference between DDL and DML:
|It stands for Data Definition Language.||It stands for Data Manipulation Language.|
|It is used to create database schema and can be used to define some constraints as well.||It is used to add, retrieve or update the data.|
|It basically defines the column (Attributes) of the table.||It add or update the row of the table. These rows are called as tuple.|
|It doesn’t have any further classification.||It is further classified into Procedural and Non-Procedural DML.|
|Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc.||BASIC command present in DML are UPDATE, INSERT, MERGE etc.|
- Difference between RDBMS and DBMS
- Difference between OLAP and OLTP in DBMS
- Difference between Row oriented and Column oriented data stores in DBMS
- Need for DBMS
- Deadlock in DBMS
- Starvation in DBMS
- Disadvantages of DBMS
- Interfaces in DBMS
- DBMS | SQL | Question 2
- DBMS | SQL | Question 1
- Recoverability in DBMS
- Cascadeless in DBMS
- Use of DBMS in System Software
- Database Objects in DBMS
- File Organization in DBMS | Set 1
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to firstname.lastname@example.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
Improved By : aman neekhara