Skip to main content

Posts

Showing posts from May, 2021

Important Terminology of DBMS (Database Management System)

Database:  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. For Example, university database organizes the data about students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and deletion of data from it. 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