2 min read

Important Terminology for DBMS

The database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schemas, reports etc.
Important Terminology for DBMS

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

  • CREATE: to create a database and its objects like (table, index, views, store procedure, function, and triggers).
  • ALTER: alters the structure of the existing database.
  • DROP: delete objects from the database.
  • TRUNCATE: remove all records from a table, including all spaces allocated for the records are removed.
  • COMMENT: add comments to the data dictionary.
  • RENAME rename an object.

DML is short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE, etc., and it 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
  • MERGE: UPSERT operation (insert or update)
  • CALL: call a PL/SQL or Java subprogram
  • EXPLAIN PLAN: interpretation of the data access path.
  • DELETE: Delete all records from a database table.
  • LOCK TABLE: concurrency Control.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

  • GRANT – allow users access privileges to database.
  • REVOKE – withdraw users access privileges given by using the GRANT command.

TCL is short name of Transaction Control Language which deals with transaction within a database.

  • COMMIT – commits a transaction.
  • ROLLBACK – rollback a transaction in case of any error occurs.
  • SAVEPOINT – a point inside a transaction that allows rollback state to what it was at the time of the savepoint.
  • SET TRANSACTION – specify characteristics for the transaction.
https://i.stack.imgur.com/7uUaJ.png
Introduction of DBMS (Database Management System) | Set 1 - GeeksforGeeks
A computer science portal for geeks. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions.
https://www.geeksforgeeks.org/introduction-of-dbms-database-management-system-set-1/

#DBMS #DDL #DML #DCL #TCL #Probyto #ProbytoAI

Subscribe and follow us for latest news in AI and Tech and stay updated!

Facebook: https://facebook.com/probyto
Twitter: https://twitter.com/probyto
LinkedIn: https://linkedin.com/company/probyto
Instagram: https://instagram.com/probyto