DBMS Terminology

DDL stands for Data Definition Language, which works on database schemas and descriptions, of how the data should be stored in the database.

  • CREATE: to create a database and its objects 
  • ALTER: alters the structure of the existing database
  • DROP: delete objects from the database
  • TRUNCATE: remove all records from a table
  • COMMENT: add comments to the data dictionary
  • RENAME: rename an object

DML stands for Data Manipulation Language which deals with data manipulation and is used to store, modify, retrieve, delete and update data in a database.

  • SELECT: retrieve data from a database
  • INSERT: insert data into a table
  • UPDATE: updates existing data within a table
  • DELETE: Delete all records from a database table
  • MERGE: UPSERT operation (insert or update)
  • CALL: call a PL/SQL or Java subprogram
  • EXPLAIN PLAN: interpretation of the data access path
  • LOCK TABLE: concurrency Control

also see

C Programming language
Go Programming language
Linked List Array
Stack Queue
Puzzle Reasoning
Aptitude Simplification
Previous articleDBMS
Next articleDisplaying Images in HTML


Please enter your comment!
Please enter your name here