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]
Failure Classification in DBMS
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]
Recoverability of Schedule in DBMS
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]
DBMS vs RDBMS: Difference between DBMS and RDBMS
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]
DBMS SQL Insert Statement
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]
DBMS SQL Select Statement
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]
DBMS: SQL Drop Table
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]
DBMS: SQL Create Table
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]
DBMS: SQL Operator
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]
DBMS: SQL Commands DDL, DML, DCL, TCL, and DQL
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]
DBMS: Advantages of SQL
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]
DBMS Characteristics of SQL
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]
DBMS SQL
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 in DBMS
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]
B+ Tree File Organization in DBMS
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]
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 6
- Next Page »