Author Archives: Sumit Thakur - Page 2
Pagination in SQL Server, MySQL and Oracle with Examples
Pagination in SQL Server, MySQL and Oracle with Examples: Often, while working with the application with a huge result set in the backend, it is not desired to display all…
Structure of DBMS: Users and Interfaces with Diagram
Structure of DBMS (Database Management System): Users and Interfaces with Diagram: A DBMS – Database management system is a complex software system that stores a huge amount of data and…
What is Schedule in DBMS? Types, Advantages, Disadvantages
What is Schedule in DBMS? Types, Advantages, Disadvantages: In DBMS, the schedule is the sequence following which the instruction of transactions will be performed. It is a process using which…
Decomposition in DBMS? Types, Advantages, Properties, Issues
Decomposition in DBMS? Types, Advantages, Properties, Issues: Decomposition can be defined as a database management system process for dividing a single relation into multiple sub-relations. Its main purpose is to…
What is Serializability in DBMS? Types, Advantages, and Significance
What is Serializability in DBMS? Types, Advantages, and Significance: Serializability can be called a process used for finding the correct non-serial schedules in the database. It basically helps maintain the…
What is Traditional File Processing System And Its Characteristics
What is Traditional File Processing System And Its Characteristics: Before the use of computer, a manual file system was used to maintain the records and files. All the data was…
TCL Commands in SQL- Transaction Control Language Examples
TCL Commands in SQL- Transaction Control Language Examples: Transaction Control Language can be defined as the portion of a database language used for maintaining consistency of the database and managing…
15 Characteristics of Database Management System
Characteristics of Database Management System: At the end of this article you will be able to understand what are the basic Characteristics of Database management systems? There are numerous characteristics…
SQL Update Statement – Update Query In SQL
The Update is one of the DML (data manipulation) commands that are essentially used to update the existing data in the records/tuples. Pick a case of a company as an…
SQL – INSERT INTO STATEMENT
Insert statement is a basic yet most useful command in SQL to insert new data (records) into the table in the database. There are various ways in which data can…