In the previous chapters, you learned how to identify a recoverable schedule and what kind of failures can occur in DBMS. In this chapter, you… [Read More]

In DBMS there are several transactions running in a specified schedule. However sometimes these transactions fail due to several reasons. In previous tutorial, we learned… [Read More]

In this guide, you will learn a very important concept in DBMS: Recoverability of Schedule. There are times when few transactions in a schedule fail,… [Read More]

In this guide, you will learn the difference between DBMS (Database Management System) and RDBMS (Relational Database Management System). What is a DBMS (Database Management… [Read More]

INSERT statement is used to insert the data into the table in database. You can insert values of specified columns or an entire record containing… [Read More]

SELECT statement is used to fetch (retrieve) the data from the database. In this tutorial, you will learn how to retrieve the desired data from… [Read More]

DROP TABLE statement is used to delete the existing table from the database. There is another statement TRUNCATE TABLE which is also used to delete… [Read More]

CREATE TABLE statement is used to create a table in database. This statement creates a table with the specified column and datatypes. Syntax: CREATE TABLE… [Read More]

In this article, you will learn the various operators that can be used in SQL queries. Operators in SQL can be categorised as follows: Arithmetic… [Read More]

SQL commands are instructions to the database to perform a specific operation. For example, you can use SELECT command to read the data from database,… [Read More]

In this article, we will discuss the advantages of SQL. We have already seen the several features of SQL in characteristics of SQL. Here, we… [Read More]

In this article, you will learn the characteristics of SQL. Characteristics of SQL Easy to Learn: SQL is user-friendly, english like language that makes it… [Read More]

Structured Query Language, popularly known as SQL is a domain specific language used to manage data in relational database management systems (RDBMS). It allows the… [Read More]

Cluster file organization is different from the other file organization methods. Other file organization methods mainly focus on organizing the records in a single file… [Read More]

Similar to ISAM file organization, B+ file organization also works with key & index value of the records. It stores the records in a tree… [Read More]